---- Original Message -----
From: "Eliot Cline" <eliotcline(at)hotmail(dot)com>
Sent: Monday, December 20, 1999 11:47 PM
Subject: [INTERFACES] ODBC, large objects and tracing
> I am porting an application from Win NT to Linux. It is an application for
> storing, querying, subsetting and exporting geographic data. On NT the
> is stored in MS SQL Server, database access is handled through a dll which
> handles all requests for data from the application. The dll is written
> ODBC 3 as the interface to SQL Server.
> I installed postgresql 6.53 a few days ago and had a go at getting the dll
> code working with the postgresql odbc driver. As the driver is written for
> odbc 2.0, I decided to try the UnixOdbc driver and driver manager. Using
> their package my code compiled perfectly, with NO modifications.
> However, I immediatley ran into trouble when inserting into large-objects
> (Lot's of blobs in this app!). In the server trace there was an error to
> effect of "Invalid large object descriptor".
> That had me stumped until yesterday, when I ran across a patch for the
> driver on this mailing list (dated Dec. 8, 99). I applied the patch (by
> hand) to the UnixODBC version of the postgres driver, and the problem went
> away. I'm impressed! I thought it was going to be way more difficult than
> If anyone is interested, I would be happy to supply the modified source
> files for the driver and a script I cobbled together to add the large
> support functions, data type and table trigger (for deleting lo's). It all
> seems to work quite well.
I'd definitely like to have a look at the script that was cobbled together
to add all that... I've been having troubles but its with the JDBC driver
and large objects, but I think its just that I haven't done all thats
necessary on the postgres side to enable it.
In response to
pgsql-interfaces by date
|Next:||From: Peter Mount||Date: 1999-12-22 19:08:21|
|Subject: Re: JDBC: Getting started with Serialization|
|Previous:||From: Adolfo Diaz||Date: 1999-12-22 16:54:31|
|Subject: INTERFACES ODBC |