Postgresql & ODBC

From: Art Fore <afore(at)sonic(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Postgresql & ODBC
Date: 2003-01-30 15:53:02
Message-ID: 3E394A5E.609@sonic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Art Fore 2003-01-31 00:57:46 [Driver Manager]Data source name not found, and no default driver specified
Previous Message Michael Calabrese 2003-01-29 23:55:37 Re: Error when accessing tables with deleted columns