Help with ODBC and Solaris

From: Daren Sefcik <daren(at)sefcik(dot)cc>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Help with ODBC and Solaris
Date: 1999-06-26 16:27:40
Message-ID: Pine.BSF.4.05.9906260901060.34075-100000@cx757770-a.fed1.sdca.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-06-26 17:38:00 Re: [INTERFACES] Inter-process communication
Previous Message Rick Sipe 1999-06-26 16:27:30 unsubscribe