From: Ken J. Wright <ken@ori-ind.com>
To: Teulings, Tim <Tim.Teulings@materna.de>
To: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: AW: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
Date: Mon, 08 Nov 1999 17:38:02 -0800
Message-ID: <3.0.32.19991108173758.00947100@ren.cncware.com> (raw)
>We use DBTools and ODBC to access Informix and DBase, too,
>without any problem, so I think we *do* handle preparing
>correctly. For me it is more likely that the ODBC driver
>for postgres misses something!?
I have been using the driver for quite a while, using dynamic sql and the
'?' for parameter binding, so I know it all works, but obviously something
is going wrong for you.
>Is there someone out there who has more knowledge about
>what the postgres ODBC driver supports and what not.
Actually, I thought we might here from Byron, but maybe he is currently
unavailable. Byron knows the guts of the driver. Maybe I can help further.
>Is there any other thing I can do or log to make the
>case more clear?
It would help to also see the trace log. Turn on tracing in the odbc driver
manager. This file can get huge real quick & bring your app to it's knees,
so turn on tracing *just* before you think the offending ODBC call is about
to be made, then turn it off after you receive the ODBC error dialog. This
should just capture information that pertains to the problem. Zip up the
logs & send to me in a private email and I'll see if I can find anything.
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ken@ori-ind.com, Tim.Teulings@materna.de
Subject: Re: AW: AW: [INTERFACES] Postgres (NT), ODBC and DBTools
In-Reply-To: <3.0.32.19991108173758.00947100@ren.cncware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox