Skip site navigation (1) Skip section navigation (2)

[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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group