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