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