Re: Using Which Driver [correct] - Mailing list pgsql-odbc

From Sivakumar K
Subject Re: Using Which Driver [correct]
Date
Msg-id B4AF8C04F762D246A1E38EC5DFAEFC0B04EFE3@blrmail2.aus.pervasive.com
Whole thread Raw
In response to Using Which Driver [correct]  (Kathy Lo <kathy.lo.ky@gmail.com>)
List pgsql-odbc

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@
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]

 

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

pgsql-odbc by date:

Previous
From: "Anoop Kumar"
Date:
Subject: Re: Continuing encoding fun....
Next
From: "Dave Page"
Date:
Subject: Re: Continuing encoding fun....