Re: Postgresql & ODBC

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