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

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

pgsql-odbc by date

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

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