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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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