Re: MSSQL To PostgreSQL Via DTS

Attached is the new mylog and psqlodbc log for the 07.03.0261 DLL.

I received the same EXCEPTION_ACCESS_VIOLATION :(

This DLL seems to work fine with regular data types (varchar, int)

Thanks for your help so far,
-Daniel Holm

-----Original Message-----
Hi Daniel,

Thanks for your report.
I seem to have found the cause of the exception.
Please retry the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html.

regards,
Hiroshi Inoue

Daniel Holm wrote:
>>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?