Re: 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