From: | Rob Yampolsky <ryampols(at)cjds(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org(dot)pgsql-odbc(at)postgresql(dot)org |
Subject: | How to configure iodbc access to local postgres db? |
Date: | 2001-04-19 17:50:56 |
Message-ID: | 3ADF257F.C826019F@cjds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc pgsql-ports |
I'm trying to get the iodbc driver manager to access postgres on the
local machine with the odbctest tool that comes with the iodbc stuff.
Having no luck. Fails on the connect attempt, and I know I'm doing
something stupid, but don't know where to look.
Help (or a good .odbc.ini) would be appreciated.
Rob
ryampols(at)cjds(dot)com
System is Mandrake 7.2 - postgres installed from RPM's on the MDK CD
(libraries in /usr/lib, postgres home is /var/lib/pgsql).
Logs this error in odbc.trace:
SQLDriverConnect ( ... )
SQL_NO_DATA_FOUND
My .odbc.ini file (accessed via ODBCINI env variable) looks like:
[ODBC Data Sources]
testdb = PostgreSQL test database
[testdb]
Driver = /usr/lib/libpsqlodbc.so.0
Description = PostgreSQL test database
Host = localhost
ServerType = postgres
Port = 5432
FetchBufferSize = 99
UserName =
Password =
Database = testdb
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no
Trace = 1
TraceFile = /tmp/odbc.trace
Debug = 1
DebugFile = /tmp/odbc.debug
CommLog = 1
From | Date | Subject | |
---|---|---|---|
Next Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-04-19 17:59:22 | Re: locale & glibc 2.2.2 |
Previous Message | Pimenov Yuri | 2001-04-19 17:49:07 | locale & glibc 2.2.2 |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-04-20 00:35:57 | Re: Re: Driver errors with Autocad (please help) |
Previous Message | Braxton Beyer | 2001-04-19 16:01:12 | DB grid |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-19 18:46:40 | Re: Postgres 7.1 RPM |
Previous Message | Bruce MacKay | 2001-04-19 17:47:18 | Error compiling 7.1 on Caldera OpenLinux |