Problem with libpsqlodbc - Mailing list pgsql-odbc

From Gilles DAROLD
Subject Problem with libpsqlodbc
Date
Msg-id 3B8BCFDF.9E30ABBD@darold.net
Whole thread Raw
List pgsql-odbc
Hi all,

I have sent some patches to the OpenLDAP dev team to have it work with
PostgreSQL and they should be applied asap, I also write a HOWTO.
This works but with a not usefull or silly workaround.

If we want to have PG fully compatible with OpenLDAP we need to resolve
a problem regarding the libpsqlodbc library.

In OpenLDAP they call the function SQLBindParameter as follow:

SQLBindParameter(sth,1,SQL_PARAM_OUTPUT,SQL_C_ULONG,SQL_INTEGER,0,0,&new_keyval,0,0);

And then the statement is executed with SQLExecDirect as follow:

rc=SQLExecDirect(sth,oc->create_proc,SQL_NTS);

What they expected is that the 'new_keyval' pointer may be modified at
execution time, with the new unique identifier returned by the query,
typically a sequence number.

It works fine with other database (mySQL, Oracle, etc.) but not with
PostgreSQL, so I suppose that the problem comes from the odbc library.

What's the problem ? Is the SQLBindParameter call is wrong ?
My knowledge is not enougth to find it, please help...

If someone could explain me what's wrong I should probably correct the
problem !

Regards,

Gilles DAROLD

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Error messages not always reported through the ODBCdriver -STATEMENT ERROR missing
Next
From: Hiroshi Inoue
Date:
Subject: Re: Problem with libpsqlodbc