No luck with the experimental driver either, 2 rows with text fields,
sizes: 80804 and 63456 bytes.

Default settings on ODBC+ driver (max length 8000 or so) result in:
> MSSQL Error: Data for source column 1 ('textfield') is too large for
the
> specified buffer size.

After modifying max length, I get various errors such as catastrophic
failure, a serious error occurred while connecting to the provider,
provider not initialized, etc. I cant get anything to work on the ODBC
driver now. I will reboot the machine and try it again later this
evening.

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
Sent: Wednesday, March 08, 2006 8:30 AM
To: Daniel Holm
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] MSSQL To PostgreSQL Via DTS

Daniel Holm wrote:
> Does anyone have any advice on copying columns of data type text or
> image from Microsoft SQL 2000 to Postgre? I have set the ODBC driver
to
> treat text as Long VarChar, and if I bump my max Long VarChar size up
-
> I get one of two errors:
>
>
>
> MSSQL Error: Data for source column 1 ('textfield') is too large for
the
> specified buffer size.
>
> or
>
> MSSQL Error: Query-based insertion or updating of BLOB values is not
> supported.

Please try psqlODBC 07.03.0260(Experimental Enhanced Branch) at
http://pgfoundry.org/projects/psqlodbc/ .

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Daniel Holm wrote:
> No luck with the experimental driver either, 2 rows with text fields,
> sizes: 80804 and 63456 bytes.
> Default settings on ODBC+ driver (max length 8000 or so) result in:
>
>>MSSQL Error: Data for source column 1 ('textfield') is too large for
>
> the
>
>>specified buffer size.
>
>
> After modifying max length, I get various errors

Were you able to connect to the database before the modification using
the experimantal driver ? Are you using the different DSN from the
one which uses the official driver ?

> such as catastrophic
> failure, a serious error occurred while connecting to the provider,
> provider not initialized, etc. I cant get anything to work on the ODBC
> driver now. I will reboot the machine and try it again later this
> evening.

Please replace the dll psqlodbc35w.dll by the one at
http://www.geocities.jp/inocchichich...dbc/index.html
and send the mylog output to me.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq