Thread: No dice trying to connect to an ODBC data source

No dice trying to connect to an ODBC data source

From

"Robby Slaughter"

Date:

12 June 2001, 03:05:31

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

Re: No dice trying to connect to an ODBC data source

From

Hiroshi Inoue

Date:

13 June 2001, 07:37:13

Robby Slaughter wrote:
>
> 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:
>

[snip]

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

Seems *user* isn't specified.

regards,
Hiroshi Inoue