Thread: postgresql-odbc vs. unixODBC

postgresql-odbc vs. unixODBC

From
Rainer Hochreiter
Date:
hi,

does anybody know what the differences are between postgresql-odbc
and unixODBC? because connection via postgresql-odbc work and
via unixODBC fails!

here some infos:

my /etc/odbcinst.ini:
---------------------
[PostgreSQL]
Description     = ODBC for PostgreSQL (postgresql-odbc)
Driver          = /usr/lib/psqlodbc.so
FileUsage       = 1

[PostgreSQL2]
Description     = ODBC for PostgreSQL (unixODBC)
Driver          = /usr/lib/libodbcpsql.so
FileUsage       = 1

my /etc/odbc.ini:
-----------------
[DB1]
Description     = PostgreSQL
Driver          = PostgreSQL
Database        = DB1
ServerName      = localhost
UserName        = icp
Port            = 5432

[DB2]
Description     = PostgreSQL
Driver          = PostgreSQL2
Database        = DB2
ServerName      = localhost
UserName        = icp
Port            = 5432

my /var/lib/pgsql/data/pg_hba.conf:
-----------------------------------
local DB1 uid md5
local DB2 uid md5

isql DB1 uid pwd  => work fine
isql DB2 uid pwd  => results in "[ISQL]ERROR: Could not SQLConnect"

any hints welcome!

cheers, rainer

Re: postgresql-odbc vs. unixODBC

From
Hajo Kirchhoff
Date:
Hi,


>
> does anybody know what the differences are between postgresql-odbc
> and unixODBC? because connection via postgresql-odbc work and
> via unixODBC fails!

you should check the driver versions. I think I remember seeing a post
that said that the postgreSQL unixODBC is an outdated version of the
postgreSQL ODBC driver that was included by the unixODBC team.

At any rate I'd always use the latest driver available directly from the
ODBC team here.

Hajo


>
> here some infos:
>
> my /etc/odbcinst.ini:
> ---------------------
> [PostgreSQL]
> Description     = ODBC for PostgreSQL (postgresql-odbc)
> Driver          = /usr/lib/psqlodbc.so
> FileUsage       = 1
>
> [PostgreSQL2]
> Description     = ODBC for PostgreSQL (unixODBC)
> Driver          = /usr/lib/libodbcpsql.so
> FileUsage       = 1
>
> my /etc/odbc.ini:
> -----------------
> [DB1]
> Description     = PostgreSQL
> Driver          = PostgreSQL
> Database        = DB1
> ServerName      = localhost
> UserName        = icp
> Port            = 5432
>
> [DB2]
> Description     = PostgreSQL
> Driver          = PostgreSQL2
> Database        = DB2
> ServerName      = localhost
> UserName        = icp
> Port            = 5432
>
> my /var/lib/pgsql/data/pg_hba.conf:
> -----------------------------------
> local DB1 uid md5
> local DB2 uid md5
>
> isql DB1 uid pwd  => work fine
> isql DB2 uid pwd  => results in "[ISQL]ERROR: Could not SQLConnect"
>
> any hints welcome!
>
> cheers, rainer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


--






--------------------------------------------
Lit Window Library - Speed up GUI coding 10x
   http://www.litwindow.com/library?src=ml

wxVisualSetup - integrate wxWidgets into Visual Studio .NET
   http://www.litwindow.com/Products/products.html?src=ml

BugLister - Defect Tracker
   http://www.litwindow.com/buglister?src=ml

Tips & Tricks for wxWidgets & MS Visual Studio
   http://www.litwindow.com/Knowhow/knowhow.html?src=ml