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.
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Kathy Lo
Sent: Tuesday, August 30, 2005 11:38 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Using Which Driver [correct]
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.
From psqlodbc-08.00.0102.tar.gz, I installed
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!