[interface] IODBC : How to fetch errors?

From: "Bart A(dot)M(dot) Jourquin" <jourquin(at)message(dot)fucam(dot)ac(dot)be>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [interface] IODBC : How to fetch errors?
Date: 1999-01-14 14:08:53
Message-ID: 369DFA75.CDEB2B4F@fucam.ac.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Stefan Kapfhammer 1999-01-14 15:03:03
Previous Message Hannu Krosing 1999-01-14 11:05:22 Re: [INTERFACES] interface to MSsql server