Re: ADO-Error when inserting row with text column with large text

Hello Heikki,

thanks for your quick answer !
I have no possibility to update the server in the next time. But i must work the ODBC-Insert quickly.
Because inserting the row with the lage text column works in pgAdmin III, may be the ODBC-driver is the reason. Can i update the ODBC-Driver only to make it work ?

Thanks for you help !

Josef Springer

On 14.06.2013 09:57, Heikki Linnakangas wrote:

On 14.06.2013 10:00, Josef Springer wrote:

Hello,

i am using
- PostgreSQL 8.2.5
- ODBC: PostgreSQL Unicode 8.02.04.0

You seriously need to upgrade. PostgreSQL 8.2.5 was released in 2007, and is no longer supported by the community. That ODBC version is really old as well. There has been a lot of bug fixes and improvements in both the server and the driver since.

I'd recommend upgrading the server immediately to the last 8.2 release, 8.2.23, as that only requires replacing the binaries. Then start planning for a major version upgrade to PostgreSQL 9.2.

Try with the latest version of the ODBC driver, it should also work with older server versions. I don't know if it will help with your problem, but since you should upgrade anyway, it's worth doing that first, and see if it happens to fix it.

- Heikki