Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group