Re: [INTERFACES] ODBC-Interfaces - connection options ? Error ! - Mailing list pgsql-interfaces

From Nuchanach Klinjun
Subject Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
Date
Msg-id Pine.OSF.4.10.9909210941450.13034-100000@johann.inet.co.th
Whole thread Raw
In response to ODBC-Interfaces - connection options ? Error !  (Jyry Kuukkanen <jyry@laserle.fi>)
Responses Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !  (marten@feki.toppoint.de)
Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !  (Jyry Kuukkanen <jyry@laserle.fi>)
List 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@inet.co.th



pgsql-interfaces by date:

Previous
From: The Hermit Hacker
Date:
Subject: RE: [INTERFACES] pgAdmin v6.5.1 Release
Next
From: Constantin Teodorescu
Date:
Subject: Re: [INTERFACES] pgaccess Q