Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !

From: Nuchanach Klinjun <nuchk(at)inet(dot)co(dot)th>
To: Jyry Kuukkanen <jyry(at)laserle(dot)fi>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
Date: 1999-09-21 02:46:53
Message-ID: Pine.OSF.4.10.9909210941450.13034-100000@johann.inet.co.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Mon, 20 Sep 1999, Jyry Kuukkanen wrote:

> >Hello,
>
> > I've a problem in the very first state of the odbc-connection from a
> > NT 4.0, SP4 and my ODBC driver for PostgreSQL and I get the following
> > output from my ODBC driver:.
>
> > My simple question: why !? What is the "unknown connect option" ?
>
>
> Unfortunately, I can't help you, but I've run into same feature (?) using
> Lotus Approach as a client.
>
> I think the key to the problem is in the log file about here:
>
> SQLDriverConnect(out)='DSN=PITPSQL;plaahplaah.....;
^^^^^^^^^^^^^^^^^

I think so also because I never seen the option 'plaahplaah' anywhere,the
syntax to sent the connection parameter should be in the list below..(the
list below is not the full option, you can see all about it in tne psqlodbc log file)

SQLDriverConnect(out)='DSN=yourDSN;DATABASE=dbname;SERVER=yourSrv;UID=uname;PWD=upwd;...;

so,please check and try again

Cheers,

> CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041,
> vParam=1526592', errnum=205 vParam=1526592', errnum=205, errmsg='Unknown
> connect option (Set)
>
> but how to get around it?
>
>
> --Jyry
>
>
>
> ************
>

-----------------------------------------
Nuchanach Klinjun
R&D Project. Internet Thailand
Email: nuchk(at)inet(dot)co(dot)th

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Constantin Teodorescu 1999-09-21 05:19:26 Re: [INTERFACES] pgaccess Q
Previous Message The Hermit Hacker 1999-09-21 01:53:30 RE: [INTERFACES] pgAdmin v6.5.1 Release