Postgres Pro
Downloads
Home   >   mailing lists

Thread: large Objects through ODBC/ADO

large Objects through ODBC/ADO

From
Thomas Günther
Date:

Hello there,

 

im trying to deal with lo from psqlodbc Ver. 8.2.0200, but I get different errors.

 

In serverlog I see:

 

2007-03-27 14:26:24 CEST 192.168.0.0 46090cb1.4657:16FEHLER:  Fehler »Syntaxfehler« bei »oE6hMBrFP6« bei Zeichen 2160

2007-03-27 14:26:24 CEST 192.168.0.0 46090cb1.4657:17ANWEISUNG:  BEGIN;update "public"."dms_rechnungen" set "content" = JVBERi0xLjMKMyAwIG9iago8PC9UeXBlIC9QYWdlCi9QYXJlbnQgMSAwI

FIKL1Jlc291cmNlcyAyIDAgUgovQW5ub3RzIFs8PC9UeXBlIC9Bbm5vdCAvU3VidHlwZSAvTGluayAvUmVjdCBbMzk2Ljg1IDc5OS4zNyA1NjYuOTMgNzA4LjA5XSAvQm9yZGVyIFswIDAgMF0gL0EgPDwvUyAvVVJJIC9VUkkgKGh0dHA6Ly93d3cuaW50ZXJuZXQyNC5kZSk+Pj4+PDwvVHlwZSAvQW5ub3QgL1N1YnR5cGUgL0xpbmsgL1JlY3QgWzU5LjUzIDY5Mi44MiAxMTIuNzUgNjg0LjgyXSAvQm9yZGVyIFswIDAgMF0gL0EgPDwvUyAvVVJJIC9VUkkgKGh0dHA6Ly93d … where ctid = '(614, 4)' and "recordid" = 460446

 

The content  of large object in query is truncate by me.

 

Any idea?

 

Best regards

Thomas Günther
- Entwickler -
----------------------------------------------
IMS Internet-Media-Service GmbH
Bayrische Str. 18
D-01069 Dresden

Geschäftsführer: Axel C.E. Wittig

Registergericht: Amtsgericht Dresden HRB 12 899

 

Fon:   +49 (0)3 51 / 2 11 20 57
Fax:   +49 (0)3 51 / 2 11 20 20

mailto:guenther@internet24.de
http://www.internet24.de

 

Re: large Objects through ODBC/ADO

From
Ludek Finstrle
Date:
> im trying to deal with lo from psqlodbc Ver. 8.2.0200, but I get different
> errors.
>
> In serverlog I see:

commonlog from ODBC driver would be much more useful for us.
If commonlog isn't enough we will ask you for mylog (it is much more
verbose).

Regards,

Luf

Re: large Objects through ODBC/ADO

From
Ludek Finstrle
Date:
> im adding mylog and psqlodbc Logs. My project is actually run on postgres
> 8.1.

Ok, I see it in logs. BTW could you try latest snapshot from:
http://www.geocities.jp/inocchichichi/psqlodbc/index.html

I think Hiroshi has solved the problem some time ago.

Regards,

Luf

P.S. Please always cc: pgsql-odbc mailling list.

> -----Ursprüngliche Nachricht-----
> Von: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] Im Auftrag von Ludek Finstrle
> Gesendet: Donnerstag, 29. März 2007 08:29
> An: Thomas Günther
> Cc: pgsql-odbc@postgresql.org
> Betreff: Re: [ODBC] large Objects through ODBC/ADO
>
> > im trying to deal with lo from psqlodbc Ver. 8.2.0200, but I get different
> > errors.
> >
> > In serverlog I see:
>
> commonlog from ODBC driver would be much more useful for us.
> If commonlog isn't enough we will ask you for mylog (it is much more
> verbose).
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster