Re: MSSQL To PostgreSQL Via DTS

From: "Daniel Holm" <Daniel(dot)Holm(at)interworksinc(dot)com>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: MSSQL To PostgreSQL Via DTS
Date: 2006-03-09 05:27:03
Message-ID: 22CFEEFF5C5D60429D6B0572DB26625928F69F@iwsbsrv1.InterWorksok.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
mylog_5140.zip application/x-zip-compressed 9.0 KB
mylog_6056.zip application/x-zip-compressed 9.0 KB
mylog_3476.zip application/x-zip-compressed 10.1 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2006-03-09 13:48:14 Re: MSSQL To PostgreSQL Via DTS
Previous Message Hiroshi Inoue 2006-03-09 01:05:15 Re: MSSQL To PostgreSQL Via DTS