Re: MSSQL To PostgreSQL Via DTS

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Daniel Holm <Daniel(dot)Holm(at)interworksinc(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: MSSQL To PostgreSQL Via DTS
Date: 2006-03-09 13:48:14
Message-ID: 4410321E.1030505@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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?

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Daniel Holm 2006-03-09 14:59:29 Re: MSSQL To PostgreSQL Via DTS
Previous Message Daniel Holm 2006-03-09 05:27:03 Re: MSSQL To PostgreSQL Via DTS