Thread: Postgresql & ODBC

Postgresql & ODBC

From
Art Fore
Date:
I went through the info on the documentation to setup ODBC for
Postgresql, but when I use isql PostgresQL-test, I get a no connect
error. Could someone tell me what I did wrong? The two ini files are
below. I can connect with Rekall, but it does not use ODBC, it uses
python script.

odbc.ini

[PostgreSQL]
Description         = Test to Postgres
Driver              = PostgreSQL
Trace               = Yes
TraceFile           = sql.log
Database            = test
Servername          = localhost
UserName            =
Password            =
Port                = 5432
Protocol            = 6.4
ReadOnly            = No
RowVersioning       = No
ShowSystemTables    = No
ShowOidColumn       = No
FakeOidIndex        = No
ConnSettings        =

odbcinst.ini

[PostgreSQL]
Description    = PostgreSQL driver
Driver    = /usr/lib/unixODBC/libodbcpsql.so
Setup    = /usr/lib/unixODBC/libodbcpsqlS.so
FileUsage    = 1



Re: Postgresql & ODBC

From
Giuliano Gavazzi
Date:
At 7:53 -0800 2003/01/30, Art Fore wrote:
>I went through the info on the documentation to setup ODBC for
>Postgresql, but when I use isql PostgresQL-test, I get a no connect
>error. Could someone tell me what I did wrong? The two ini files are
>below. I can connect with Rekall, but it does not use ODBC, it uses
>python script.
>
>odbc.ini
>
>[PostgreSQL]
>Description         = Test to Postgres
>Driver              = PostgreSQL
>Trace               = Yes
>TraceFile           = sql.log
>Database            = test
>Servername          = localhost
>UserName            =
>Password            =
>Port                = 5432
>Protocol            = 6.4
>ReadOnly            = No
>RowVersioning       = No
>ShowSystemTables    = No
>ShowOidColumn       = No
>FakeOidIndex        = No
>ConnSettings        =
>
>odbcinst.ini
>
>[PostgreSQL]
>Description    = PostgreSQL driver
>Driver    = /usr/lib/unixODBC/libodbcpsql.so
>Setup    = /usr/lib/unixODBC/libodbcpsqlS.so
>FileUsage    = 1
>

I do not know isql, but your odbc.ini does not contain the list of
datasources and the definition of the PostgresQL-test datasource
itself.

Giuliano