Thread: Using Which Driver [correct]

Using Which Driver [correct]

From
Kathy Lo
Date:
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

Re: Using Which Driver [correct]

From
"Sivakumar K"
Date:

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

Re: Using Which Driver [correct]

From
"Dave Page"
Date:
 


From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Sivakumar K
Sent: 06 September 2005 06:50
To: Kathy Lo; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] 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.

 

Of which 08.01.0103 is the latest, though if you can wait a couple of days, I expect there will be a new one.

 

Regards, Dave.

Re: Using Which Driver [correct]

From
Cleber Nardelli
Date:
Hi...

How I make to make download of the last version of psqlodbc 08.01.0103?

Thank you
Cleber.

2005/9/6, Dave Page <dpage@vale-housing.co.uk>:
>
>
> ________________________________
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Sivakumar K
> Sent: 06 September 2005 06:50
> To: Kathy Lo; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] 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.
>
>
>
> Of which 08.01.0103 is the latest, though if you can wait a couple of days,
> I expect there will be a new one.
>
>
>
> Regards, Dave.


--
Cleber Nardelli
IPM Automação e Consultoria
9998-8670

Re: Using Which Driver [correct]

From
"Dave Page"
Date:

> -----Original Message-----
> From: Cleber Nardelli [mailto:clebernardelli@gmail.com]
> Sent: 06 September 2005 20:13
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Using Which Driver [correct]
>
> Hi...
>
> How I make to make download of the last version of psqlodbc
> 08.01.0103?
>

Download from http://www.postgresql.org/ftp/odbc/versions/snapshots/

Regards, Dave