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@cjds.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