large Objects through ODBC/ADO
am 29.03.2007 07:59:47 von guentherThis 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
http://www.internet24.de
=20
------=_NextPart_000_000C_01C771D8.383D6210
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
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--