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-08 22:27:30 |
Message-ID: | 22CFEEFF5C5D60429D6B0572DB26625928F68D@iwsbsrv1.InterWorksok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
No luck with the experimental driver either, 2 rows with text fields,
sizes: 80804 and 63456 bytes.
Default settings on ODBC+ driver (max length 8000 or so) result in:
> MSSQL Error: Data for source column 1 ('textfield') is too large for
the
> specified buffer size.
After modifying max length, I get various errors such as catastrophic
failure, a serious error occurred while connecting to the provider,
provider not initialized, etc. I cant get anything to work on the ODBC
driver now. I will reboot the machine and try it again later this
evening.
-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
Sent: Wednesday, March 08, 2006 8:30 AM
To: Daniel Holm
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Ng | 2006-03-09 00:51:31 | Support for PostgreSQL 8.1.3 stable |
Previous Message | Campbell, Greg | 2006-03-08 20:19:33 | Re: Need help postgre with visual basic |