large Objects through ODBC/ADO

large Objects through ODBC/ADO

am 29.03.2007 07:59:47 von guenther

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C771D8.383D6210
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello there,

=20

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

=20

In serverlog I see:

=20

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" =3D
JVBERi0xLjMKMyAwIG9iago8PC9UeXBlIC9QYWdlCi9QYXJlbnQgMSAwI

FIKL1Jlc291cmNlcyAyIDAgUgovQW5ub3RzIFs8PC9UeXBlIC9Bbm5vdCAvU 3VidHlwZSAvTG=
lua
yAvUmVjdCBbMzk2Ljg1IDc5OS4zNyA1NjYuOTMgNzA4LjA5XSAvQm9yZGVyI FswIDAgMF0gL0=
EgP
DwvUyAvVVJJIC9VUkkgKGh0dHA6Ly93d3cuaW50ZXJuZXQyNC5kZSk+Pj4+P DwvVHlwZSAvQW=
5ub
3QgL1N1YnR5cGUgL0xpbmsgL1JlY3QgWzU5LjUzIDY5Mi44MiAxMTIuNzUgN jg0LjgyXSAvQm=
9yZ
GVyIFswIDAgMF0gL0EgPDwvUyAvVVJJIC9VUkkgKGh0dHA6Ly93d =85 where ctid =3D =
'(614,
4)' and "recordid" =3D 460446

=20

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

=20

Any idea?

=20

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

=20

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

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

=20


------=_NextPart_000_000C_01C771D8.383D6210
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Diso-8859-1">









style=3D'font-size:10.0pt;
font-family:Arial'>Hello there,



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>im trying to deal with lo from psqlodbc Ver. =
8.2.0200,
but I get different errors.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>In serverlog I =
see:



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>2007-03-27 14:26:24 CEST 192.168.0.0
46090cb1.4657:16FEHLER:=A0 Fehler »Syntaxfehler« bei =
»oE6hMBrFP6« bei Zeichen
2160



style=3D'font-size:10.0pt;
font-family:Arial'>2007-03-27 14:26:24 CEST 192.168.0.0
46090cb1.4657:17ANWEISUNG:=A0 BEGIN;update
"public"."dms_rechnungen" set "content" =
=3D
JVBERi0xLjMKMyAwIG9iago8PC9UeXBlIC9QYWdlCi9QYXJlbnQgMSAwI n>



style=3D'font-size:10.0pt;
font-family:Arial'>FIKL1Jlc291cmNlcyAyIDAgUgovQW5ub3RzIFs8PC 9UeXBlIC9Bbm5=
vdCAvU3VidHlwZSAvTGluayAvUmVjdCBbMzk2Ljg1IDc5OS4zNyA1NjYuOTM gNzA4LjA5XSAv=
Qm9yZGVyIFswIDAgMF0gL0EgPDwvUyAvVVJJIC9VUkkgKGh0dHA6Ly93d3cu aW50ZXJuZXQyN=
C5kZSk+Pj4+PDwvVHlwZSAvQW5ub3QgL1N1YnR5cGUgL0xpbmsgL1JlY3QgW zU5LjUzIDY5Mi=
44MiAxMTIuNzUgNjg0LjgyXSAvQm9yZGVyIFswIDAgMF0gL0EgPDwvUyAvVV JJIC9VUkkgKGh=
0dHA6Ly93d
… where ctid =3D '(614, 4)' and "recordid" =3D =
460446



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:
10.0pt;font-family:Arial'>The content =A0of large object in query is =
truncate by
me.



style=3D'font-size:
10.0pt;font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>Any idea?



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;font-family:Arial'>Best
regards



Thomas Günther

- Entwickler -

----------------------------------------------

IMS Internet-Media-Service GmbH

Bayrische Str. 18

D-01069 Dresden



style=3D'font-size:10.0pt;
font-family:Arial'>Geschäftsführer: Axel C.E. =
Wittig



style=3D'font-size:10.0pt;
font-family:Arial'>Registergericht: Amtsgericht Dresden HRB 12 =
899



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>Fon:   +49 (0)3 51 / 2 11 20 57

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



title=3D"blocked::mailto:heerwagen@internet24.de">mailto:gue nther@interne=
t24.de


title=3D"blocked::http://www.internet24.de/">http://www.inte rnet24.de=



style=3D'font-size:
12.0pt'> 









------=_NextPart_000_000C_01C771D8.383D6210--

Re: large Objects through ODBC/ADO

am 29.03.2007 08:28:59 von Ludek Finstrle

> 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

Re: large Objects through ODBC/ADO

am 06.04.2007 14:37:21 von Ludek Finstrle

> im adding mylog and psqlodbc Logs. My project is actually run on postgr=
es
> 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
>=20
> > im trying to deal with lo from psqlodbc Ver. 8.2.0200, but I get diff=
erent
> > errors.
> >=20
> > In serverlog I see:
>=20
> 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).
>=20
> Regards,
>=20
> Luf
>=20
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 2: Don't 'kill -9' the postmaster




---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate