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: (view raw or whole 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

> ./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

TraceFile       = /tmp/odbc.trace
Trace           = ON
Driver          = /usr/local/pgsql/lib/
Description     = Daren
Host            = localhost
ServerType      = PostgreSQL
FetchBufferSize = 99
UserName        = postgres
Password        = ****(guess me)
PORT            = 5432
Database        = daren
ServerOptions   =
ConnectOptions  =
Options         =
ReadOnly        = no

Driver = /usr/local/pgsql/lib/

What am I doing wrong..??


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-2015 The PostgreSQL Global Development Group