Re: How to configure iodbc access to local postgres db?

Rob Yampolsky wrote:
>
> 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
>

Please try the following.

1) Use ~/.odbc.ini instead of ODBCINI.
2) psqlodbc driver doesn't see the 'Host' entry.
Replace the 'Host' entry by 'Servername' entry.
3) Set a valid user name to the 'Username' Entry.
4) Remove blanks around '='. For example,
Driver=/usr/lib/libsqlodbc.so.0

Good luck.
Hiroshi Inoue

> 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