ODBC escape convert error

ODBC escape convert error

am 11.06.2008 19:48:23 von Richard Broersma

------=_Part_12980_27897815.1213206503825
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I've attached a log file with the code for a prepared insert command.
However, when it is executed, I am getting the error:

ODBC escape convert error.

It looks like the query never makes it to the sever becuase I don't
see any statement logged for it. Does anyone have any ideas?

--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

------=_Part_12980_27897815.1213206503825
Content-Type: application/octet-stream; name=preparedinsert.log
Content-Transfer-Encoding: base64
X-Attachment-Id: f_fhc7pzrz0
Content-Disposition: attachment; filename=preparedinsert.log

UHVibGljIEZ1bmN0aW9uIGdldHByZXBhcmVkVGFncyhjb24gQXMgQURPREIu
Q29ubmVjdGlvbikgQXMgQURPREIuQ29tbWFuZA0KICAgIERpbSBwY21kIEFz
IE5ldyBBRE9EQi5Db21tYW5kDQogICAgDQogICAgU2V0IHBjbWQuQWN0aXZl
Q29ubmVjdGlvbiA9IGNvbg0KICAgIHBjbWQuUHJlcGFyZWQgPSBUcnVlDQog
ICAgDQogICAgV2l0aCBwY21kDQogICAgICAgIC5Db21tYW5kVGV4dCA9ICIi
DQogICAgICAgIC5Db21tYW5kVGV4dCA9IC5Db21tYW5kVGV4dCAmICJJTlNF
UlQgSU5UTyBEZXYuVGFncyggaW5zdHJ1bWVudGNvZGUsIGluc3RydW1lbnRz
dWZmLCBhcmVhLCBsb29wbmJyLCBoYXNiYWNrdXAsIGVuZHByb2plY3RuYnIs
ICIicCZpZHNlY3Rpb24iIiApICAgICAgICAgICAgICAgICAgIiAmIHZiTmV3
TGluZQ0KICAgICAgICAuQ29tbWFuZFRleHQgPSAuQ29tbWFuZFRleHQgJiAi
ICAgICBTRUxFQ1QgQS5pbnN0cnVtZW50Y29kZSwgQS5JbnN0cnVtZW50c3Vm
ZiwgQS5hcmVhLCBBLmxvb3BuYnIsIEEuaGFzYmFja3VwLCBBLmVuZHByb2pl
Y3RuYnIsIEEucGlkICAgICAgICAgICAgICAgICAgICAgICAgICAgICIgJiB2
Yk5ld0xpbmUNCiAgICAgICAgLkNvbW1hbmRUZXh0ID0gLkNvbW1hbmRUZXh0
ICYgIiAgICAgICBGUk9NICggVkFMVUVTKCA/LCA/LCA/LCA/LCA/LCA/LCA/
ICkpIEFTIEEoIGluc3RydW1lbnRjb2RlLCBpbnN0cnVtZW50c3VmZiwgYXJl
YSwgbG9vcGJuciwgaGFzYmFja3VwLCBlbmRwcm9qZWN0LCBwaWQgKSAgICAi
ICYgdmJOZXdMaW5lDQogICAgICAgIC5Db21tYW5kVGV4dCA9IC5Db21tYW5k
VGV4dCAmICIgIExFRlQgSk9JTiBEZXYuVGFncyBBUyBUICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgIiAmIHZiTmV3TGluZQ0KICAgICAgICAuQ29tbWFuZFRleHQgPSAuQ29t
bWFuZFRleHQgJiAiICAgICAgICAgT04gKCBBLmluc3RydW1lbnRjb2RlLCBB
Lmluc3RydW1lbnRzdWZmLCBBLmFyZWEsIEEubG9vcG5iciApID0gKCBULmlu
c3RydW1lbnRjb2RlLCBULmluc3RydW1lbnRzdWZmLCBULmFyZWEsIFQubG9v
cG5iciApICIgJiB2Yk5ld0xpbmUNCiAgICAgICAgLkNvbW1hbmRUZXh0ID0g
LkNvbW1hbmRUZXh0ICYgIiAgICAgIFdIRVJFIHsgVC5pbnN0cnVtZW50Y29k
ZSwgVC5pbnN0cnVtZW50c3VmZiwgVC5hcmVhLCBULmxvb3BuYnIgKSBJUyBO
VUxMOyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAiICYgdmJOZXdMaW5lDQogICAgICAgIC5QYXJhbWV0ZXJz
LkFwcGVuZCAuQ3JlYXRlUGFyYW1ldGVyKDAsIGFkVmFyQ2hhciwgYWRQYXJh
bUlucHV0LCA0KQ0KICAgICAgICAuUGFyYW1ldGVycy5BcHBlbmQgLkNyZWF0
ZVBhcmFtZXRlcigxLCBhZFZhckNoYXIsIGFkUGFyYW1JbnB1dCwgMSkNCiAg
ICAgICAgLlBhcmFtZXRlcnMuQXBwZW5kIC5DcmVhdGVQYXJhbWV0ZXIoMiwg
YWRJbnRlZ2VyLCBhZFBhcmFtSW5wdXQsIDQpDQogICAgICAgIC5QYXJhbWV0
ZXJzLkFwcGVuZCAuQ3JlYXRlUGFyYW1ldGVyKDMsIGFkSW50ZWdlciwgYWRQ
YXJhbUlucHV0LCA0KQ0KICAgICAgICAuUGFyYW1ldGVycy5BcHBlbmQgLkNy
ZWF0ZVBhcmFtZXRlcig0LCBhZEJvb2xlYW4sIGFkUGFyYW1JbnB1dCwgMSkN
CiAgICAgICAgLlBhcmFtZXRlcnMuQXBwZW5kIC5DcmVhdGVQYXJhbWV0ZXIo
NSwgYWRWYXJDaGFyLCBhZFBhcmFtSW5wdXQsIDEwKQ0KICAgICAgICAuUGFy
YW1ldGVycy5BcHBlbmQgLkNyZWF0ZVBhcmFtZXRlcig2LCBhZEludGVnZXIs
IGFkUGFyYW1JbnB1dCwgMSkNCiAgICAgICAgRW5kIFdpdGgNCiAgICANCiAg
ICBTZXQgZ2V0cHJlcGFyZWRUYWdzID0gcGNtZA0KICANCkVuZCBGdW5jdGlv
bg0KDQo=

------=_Part_12980_27897815.1213206503825
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

------=_Part_12980_27897815.1213206503825--

Re: ODBC escape convert error

am 11.06.2008 20:49:21 von Hiroshi Inoue

Richard Broersma wrote:
> I've attached a log file with the code for a prepared insert command.
> However, when it is executed, I am getting the error:
>
> ODBC escape convert error.
>
> It looks like the query never makes it to the sever becuase I don't
> see any statement logged for it. Does anyone have any ideas?

You may have to replace '{' (ODBC escape) by '(' in the line.

.CommandText = .CommandText & " WHERE { T.instrumentcode,
T.instrumentsuff, T.area, T.loopnbr ) IS NULL;

regards,
Hiroshi Inoue

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: ODBC escape convert error

am 11.06.2008 21:36:17 von Richard Broersma

On Wed, Jun 11, 2008 at 11:49 AM, Hiroshi Inoue wrote:

> You may have to replace '{' (ODBC escape) by '(' in the line.
>
> .CommandText = .CommandText & " WHERE { T.instrumentcode,
> T.instrumentsuff, T.area, T.loopnbr ) IS NULL;

Correct again! Everything works perfectly now!


--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc