Re: Using Which Driver [correct]

Hi Kathy,

psqlodbc-08.00.0102 is the official ODBC driver of the
PostgreSQL community. This driver is also partially 3.x compliant
whereas the driver provided by unixODBC is ODBC 2 compliant. Also
psqlodbc-08.00.0102 has lot of bug fixes gone into it.

I believe the ODBC driver by unixODBC is little bit old.

I would suggest you to go and have your hands on libpq enabled ODBC
driver.

Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Kathy Lo
Sent: Tuesday, August 30, 2005 11:38 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Using Which Driver [correct]

Dear all,

I had installed Postgresql 8.0.3 as database server under Redhat Linux
9.0.

Also, I had installed unixODBC 2.2.11 and psqlodbc.so (generated from
psqlodbc-08.00.0102.tar.gz) under Redhat Linux 9.0 as client.

When I want to make ODBC connection to the database, I don't know which
driver should be used.

unixODBC 2.2.11 provides

libodbcpsql.so.2.0.0

libodbcpsqlS.so.1.0.0

From psqlodbc-08.00.0102.tar.gz, I installed

psqlodbc.so

Please provide me more information on the difference of these 2 driver.
And, from psqlodbc-08.00.0102.tar.gz, I did not find psqlodbcS.so while
unixODBC provides it.

I know that libodbcpsqlS.so is the Setup library for Postgresql. Am I
right? And, why psqlodbc-08.00.0102.tar.gz does not provide this
library?

Thank for your kindly help!

Kathy