From: Bart A.M. Jourquin <jourquin@message.fucam.ac.be>
To: pgsql-interfaces@postgresql.org
Subject: [interface] IODBC : How to fetch errors?
Date: Thu, 14 Jan 1999 15:08:53 +0100
Message-ID: <369DFA75.CDEB2B4F@fucam.ac.be> (raw)
Hi all,
I'm using PostgreSQL 6.4 on Solaris 2.6 and try to develop Unix programs
connecting to the database via IODBC and PostgreSQL ODBC driver for UN*X
(v 0.11).
I have no problems to connect and query my database, but it seems that
SQLError doesn't return any error string! The folowing code infinitely
loops while "buf" and "sqlstate" are empty strings...
/* Get statement errors */
while (SQLError (henv, hdbc, hstmt, sqlstate, NULL, buf, sizeof(buf),
NULL) == SQL_SUCCESS)
{
fprintf (stderr, "%s, SQLSTATE=%s\n", buf, sqlstate);
}
Using the same code on a Windows computer (remote) connected via the
PostgreSQL ODBC driver 6.40.0001 on the same database gives the correct
results.
My questions are:
1.) Is the problem related to IODBC or to PostgreSQL ODBC driver for
UN*X ?
2.) Is it a known problem with a known fix?
Any suggestion?
Many thanks in advance
--
Dr Bart A.M. JOURQUIN, Senior researcher
F.U.Ca.M. - Group Transport & Mobility (GTM)
Ch. de Binche, 151a, B7000 Mons, Belgium
Phone +32 (65) 32.32.93 Fax +32 (65) 32.56.91
http://www.fucam.ac.be/~jourquin
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: jourquin@message.fucam.ac.be
Subject: Re: [interface] IODBC : How to fetch errors?
In-Reply-To: <369DFA75.CDEB2B4F@fucam.ac.be>
* 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