No dice trying to connect to an ODBC data source

From: "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: No dice trying to connect to an ODBC data source
Date: 2001-06-12 04:05:03
Message-ID: EPEHLKLEHAHLONFOKNHNOECNDBAA.webmaster@robbyslaughter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Everything looks right according to the checklist in the FAQ, but
I still can't connect to my postgreSQL database through ODBC.
I can talk to it using psql. I turned on the logging feature
and here's what I get:

CONN ERROR: func=SQLGetConnectOption, desc='fOption=30002', errnum=205,
errmsg='Unknown connect option (Get)'
------------------------------------------------------------
henv=149042584, conn=149042608, status=0, num_stmts=16
sock=149049080, stmts=149057344, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=149049136, buffer_out=149053240
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
CONN ERROR: func=SQLSetConnectOption, desc='fOption=30002,
vParam=135208488', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=149042584, conn=149042608, status=0, num_stmts=16
sock=149049080, stmts=149057344, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=149049136, buffer_out=149053240
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
conn=149042608, SQLDriverConnect( in)='DSN=pgtest;', fDriverCompletion=1
DSN info:
DSN='pgtest',server='ROBMANBOX',port='5432',dbase='mydb',user='',passwd=''

onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''

Anybody have any ideas?

Thanks,
Robby

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kristis Makris 2001-06-12 16:04:43 ODBC 7.01.00.05 driver fails when text arrays are passed in as arguments to backend plpgsql functions
Previous Message Andrea Aime 2001-06-11 06:52:34 Re: [INTERFACES] The future of pgAdmin...