Redhat odbc configuration help

Redhat odbc configuration help

am 12.10.2006 07:53:40 von Robert Mijatovic

This is a multi-part message in MIME format.

------_=_NextPart_001_01C6EDC2.C48C9954
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.

=20

odbctest "dsn=3Dhsodbc"

OpenLink ODBC Demonstration program

This program shows an interactive SQL processor

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

Unknown connect option (Set), SQLSTATE=3DS1009

=20

Have a nice day.

=20

My .odbc.ini file is as follows

=20

..odbc.ini

[ODBC Data Sources]

hsodbc =3D PostgreSQL ODBC Driver DSN

=20

[hsodbc]

;Driver =3D /usr/lib/psqlodbc.so

Driver =3D /usr/lib/libodbcpsql.so

Setup =3D /usr/lib/libodbcpsqlS.so

Description =3D PostgreSQL ODBC Driver DSN

DSN=3Dhsodbc

Server =3D localhost

Port =3D 8477

;Protocol =3D 6.4

Protocol =3D 8.0

Username=3Dbilly

Password=3Dletmein

Database=3Dhome

ReadOnly=3Dno

ServerType=3Dpostgres

FetchBufferSize =3D 99

ServerOptions =3D

ConnectOptions =3D

Trace =3D Yes

TraceFile =3D /tmp/PostgreSQL_test_trace.log

Debug =3D 1

DebugFile =3D /tmp/PostgreSQL_test_debug.log

=20

[Default]

Driver=3D/usr/lib/libodbcpsql.so

;Driver=3D/usr/lib/psqlodbc.so

[ODBC]

InstallDir =3D /usr/lib


------_=_NextPart_001_01C6EDC2.C48C9954
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">









style=3D'font-size:10.0pt;
font-family:Arial'>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.



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>odbctest =
"dsn=3Dhsodbc"



style=3D'font-size:10.0pt;
font-family:Arial'>OpenLink ODBC Demonstration =
program



style=3D'font-size:10.0pt;
font-family:Arial'>This program shows an interactive SQL =
processor



style=3D'font-size:10.0pt;
font-family:Arial'>[iODBC][Driver Manager]Driver's SQLSetConnectOption =
failed,
SQLSTATE=3DIM006



style=3D'font-size:10.0pt;
font-family:Arial'>Unknown connect option (Set), =
SQLSTATE=3DS1009



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>Have a nice day.



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>My .odbc.ini file is as =
follows



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>.odbc.ini



style=3D'font-size:10.0pt;
font-family:Arial'>[ODBC Data Sources]



style=3D'font-size:10.0pt;
font-family:Arial'>hsodbc =3D PostgreSQL ODBC Driver =
DSN



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>[hsodbc]



style=3D'font-size:10.0pt;
font-family:Arial'>;Driver       =3D =
/usr/lib/psqlodbc.so



style=3D'font-size:10.0pt;
font-family:Arial'>Driver       =3D =
/usr/lib/libodbcpsql.so



style=3D'font-size:10.0pt;
font-family:Arial'>Setup        &=
nbsp;  =3D /usr/lib/libodbcpsqlS.so



style=3D'font-size:10.0pt;
font-family:Arial'>Description  =3D PostgreSQL ODBC Driver =
DSN



style=3D'font-size:10.0pt;
font-family:Arial'>DSN=3Dhsodbc



style=3D'font-size:10.0pt;
font-family:Arial'>Server       =3D =
localhost



style=3D'font-size:10.0pt;
font-family:Arial'>Port         =
=3D 8477



style=3D'font-size:10.0pt;
font-family:Arial'>;Protocol     =3D =
6.4



style=3D'font-size:10.0pt;
font-family:Arial'>Protocol     =3D =
8.0



style=3D'font-size:10.0pt;
font-family:Arial'>Username=3Dbilly



style=3D'font-size:10.0pt;
font-family:Arial'>Password=3Dletmein



style=3D'font-size:10.0pt;
font-family:Arial'>Database=3Dhome



style=3D'font-size:10.0pt;
font-family:Arial'>ReadOnly=3Dno



style=3D'font-size:10.0pt;
font-family:Arial'>ServerType=3Dpostgres



style=3D'font-size:10.0pt;
font-family:Arial'>FetchBufferSize =3D 99



style=3D'font-size:10.0pt;
font-family:Arial'>ServerOptions =3D



style=3D'font-size:10.0pt;
font-family:Arial'>ConnectOptions =3D



style=3D'font-size:10.0pt;
font-family:Arial'>Trace =3D Yes



style=3D'font-size:10.0pt;
font-family:Arial'>TraceFile =3D =
/tmp/PostgreSQL_test_trace.log



style=3D'font-size:10.0pt;
font-family:Arial'>Debug =3D 1



style=3D'font-size:10.0pt;
font-family:Arial'>DebugFile =3D =
/tmp/PostgreSQL_test_debug.log



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>[Default]



style=3D'font-size:10.0pt;
font-family:Arial'>Driver=3D/usr/lib/libodbcpsql.so nt>



style=3D'font-size:10.0pt;
font-family:Arial'>;Driver=3D/usr/lib/psqlodbc.so >



style=3D'font-size:10.0pt;
font-family:Arial'>[ODBC]



style=3D'font-size:10.0pt;
font-family:Arial'>InstallDir      =3D =
/usr/lib









------_=_NextPart_001_01C6EDC2.C48C9954--