Help with ODBC and Solaris - Mailing list pgsql-interfaces

From Daren Sefcik
Subject Help with ODBC and Solaris
Date
Msg-id Pine.BSF.4.05.9906260901060.34075-100000@cx757770-a.fed1.sdca.home.com
Whole thread Raw
List pgsql-interfaces
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



pgsql-interfaces by date:

Previous
From: "Peter Harvey"
Date:
Subject: unsubscribe
Next
From: Rick Sipe
Date:
Subject: unsubscribe