I am running Solaris 2.6,PostgreSQL 6.5 and
have compiled and installed the odbc that comes with PostgreSQL 6.5 and
compiled and installed iODBC 2.50.3 driver but cannot seem to get it all
working.When I run the sample odbctest that comes with iodbc I get this
error:
> ./odbctest
OpenLink ODBC Demonstration program
This program shows an interactive SQL processor
Enter ODBC connect string (? shows list): ?
DSN | Description
---------------------------------------------------------------
PostgreSQL | Daren
Enter ODBC connect string (? shows list): PostgreSQL
[iODBC][Driver Manager]Dialog failed, SQLSTATE=IM008
Have a nice day.
>
Here is my odbc.ini
[ODBC Data Sources]
PostgreSQL Database = PostgreSQL Database
[PostgreSQL]
TraceFile = /tmp/odbc.trace
Trace = ON
Driver = /usr/local/pgsql/lib/libpsqlodbc.so.0.25
Description = Daren
Host = localhost
ServerType = PostgreSQL
FetchBufferSize = 99
UserName = postgres
Password = ****(guess me)
PORT = 5432
Database = daren
ServerOptions =
ConnectOptions =
Options =
ReadOnly = no
[Default]
Driver = /usr/local/pgsql/lib/libpsqlodbc.so.0.25
What am I doing wrong..??
TIA,
Daren