Re: MSSQL To PostgreSQL Via DTS - Mailing list pgsql-odbc

From Daniel Holm
Subject Re: MSSQL To PostgreSQL Via DTS
Date
Msg-id 22CFEEFF5C5D60429D6B0572DB26625928F69F@iwsbsrv1.InterWorksok.com
Whole thread Raw
In response to MSSQL To PostgreSQL Via DTS  ("Daniel Holm" <Daniel.Holm@interworksinc.com>)
Responses Re: MSSQL To PostgreSQL Via DTS
List pgsql-odbc
>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

Attached are three zip files:
mylog_3476 - trial run 1, regular installed experimental driver
Previous call was not SQLPutData or SQLParamData

mylog_5140 - trial run 2, replaced experimental DLL with yours
Code execution exception: EXCEPTION_ACCESS_VIOLATION

mylog_6056 - trial run 3, removed experimental driver, rebooted, moved
your DLL into /system/ and ran the registry file.
Code execution exception: EXCEPTION_ACCESS_VIOLATION

Any ideas?

Attachment

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: MSSQL To PostgreSQL Via DTS
Next
From: Hiroshi Inoue
Date:
Subject: Re: MSSQL To PostgreSQL Via DTS