Sender: bart@message.fucam.ac.be
Message-ID: <369DFA75.CDEB2B4F@fucam.ac.be>
Date: Thu, 14 Jan 1999 15:08:53 +0100
From: "Bart A.M. Jourquin" <jourquin@message.fucam.ac.be>
Organization: F.U.Ca.M
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: [interface] IODBC : How to fetch errors?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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