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: marten(at)feki(dot)toppoint(dot)de
Cc: jyry(at)laserle(dot)fi, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
Date: 1999-09-23 02:35:04
Message-ID: Pine.OSF.4.10.9909230929231.25096-100000@johann.inet.co.th (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Wed, 22 Sep 1999 marten(at)feki(dot)toppoint(dot)de wrote:

> > 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)
> > 
> 
>  Actually the original posting came from me - some weeks ago. The reason
> for this has been found. The development environment I used (IBM VisualAge/ST)
> uses "special" ODBC manager and drivers from Intersolv.
> 
>  This special handling is used to check wether the user has a special
> license to use the ODBC drivers and manager.

	Oh! Ic..thanx for let me know about it.
> 
>  The checking was done within IBM Smalltalk and Ive found the call, where
> the special option has been set. Removing the call and I was able to use
> the PostgreSQL driver. 
> 
>  BUT: Ive used several third-party odbc drivers and they all work well -
> only the PostgreSQL drivers returns an error - perhaps the behaviour of
> the driver should be changed !

	Yeah, I agree. I have some problem with postgres odbc driver too
since we upgrade the database to the last version and user the last
version of pgodbc also. 

> 
>  Marten
> 
> 
> ************
> 

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


In response to

pgsql-interfaces by date

Next:From: Jens GlaserDate: 1999-09-23 05:07:16
Subject: Re: [INTERFACES] java.sql.Types problem
Previous:From: The Hermit HackerDate: 1999-09-22 20:22:50
Subject: Re: [INTERFACES] Changing User Passwords

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