Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group