How to configure iodbc access to local postgres db?

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-odbc by date

  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

Browse pgsql-ports by date

  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