Redhat odbc configuration help

From: "Robert Mijatovic" <RMijatovic(at)soulaustralia(dot)com(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Redhat odbc configuration help
Date: 2006-10-12 05:53:40
Message-ID: 1D6795FF7EFDAD44A97AFCD8EA8AF2443C8CC7@MAIL01.corporate
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I'm new to Postgres and am having some trouble getting the odbc
connectivity working. When I perform a odbctest I get the following
error.

odbctest "dsn=hsodbc"

OpenLink ODBC Demonstration program

This program shows an interactive SQL processor

[iODBC][Driver Manager]Driver's SQLSetConnectOption failed,
SQLSTATE=IM006

Unknown connect option (Set), SQLSTATE=S1009

Have a nice day.

My .odbc.ini file is as follows

.odbc.ini

[ODBC Data Sources]

hsodbc = PostgreSQL ODBC Driver DSN

[hsodbc]

;Driver = /usr/lib/psqlodbc.so

Driver = /usr/lib/libodbcpsql.so

Setup = /usr/lib/libodbcpsqlS.so

Description = PostgreSQL ODBC Driver DSN

DSN=hsodbc

Server = localhost

Port = 8477

;Protocol = 6.4

Protocol = 8.0

Username=billy

Password=letmein

Database=home

ReadOnly=no

ServerType=postgres

FetchBufferSize = 99

ServerOptions =

ConnectOptions =

Trace = Yes

TraceFile = /tmp/PostgreSQL_test_trace.log

Debug = 1

DebugFile = /tmp/PostgreSQL_test_debug.log

[Default]

Driver=/usr/lib/libodbcpsql.so

;Driver=/usr/lib/psqlodbc.so

[ODBC]

InstallDir = /usr/lib

Browse pgsql-odbc by date

  From Date Subject
Next Message Tim Clarke 2006-10-12 07:17:20 Re: LATIN1/9 conversion....
Previous Message Hiroshi Inoue 2006-10-12 02:27:57 Re: Access2000 & sequence as primary key in view : #DELETED