| Lists: | pgsql-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 |
| 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
| From: | Giuliano Gavazzi <"dev +pgsql"(at)humph(dot)com> |
|---|---|
| To: | afore(at)sonic(dot)net, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Postgresql & ODBC |
| Date: | 2003-01-31 21:16:48 |
| Message-ID: | a05200f1fba60972a0f5f@[10.0.1.13] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-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