pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC-Interfaces - connection options ? Error !
6+ messages / 3 participants
[nested] [flat]
* ODBC-Interfaces - connection options ? Error !
@ 1999-08-29 05:50 marten@feki.toppoint.de
0 siblings, 0 replies; 6+ messages in thread
From: marten@feki.toppoint.de @ 1999-08-29 05:50 UTC (permalink / raw)
To: pgsql-interfaces
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" ?
Marten
The log is following:
conn=62136336, SQLDriverConnect( in)='DSN=PITPSQL;', fDriverCompletion=2
DSN info:
DSN='PITPSQL',server='achterndiek',port='5432',dbase='testdb3',user='postgres',passwd='postgres'
readonly='1',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=0, ksqo=0, unique_index=0,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=62136336, query=' '
conn=62136336, query='set DateStyle to 'ISO''
conn=62136336, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=62136336,
SQLDriverConnect(out)='DSN=PITPSQL;DATABASE=testdb3;SERVER=achterndiek;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041,
vParam=1526592', errnum=205, errmsg='Unknown connect option (Set)'
------------------------------------------------------------
henv=62129728, conn=62136336, status=1, num_stmts=16
sock=62129744, stmts=62129792, lobj_type=-999
---------------- Socket Info -------------------------------
socket=2064, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=62142672, buffer_out=62146776
buffer_filled_in=33, buffer_filled_out=0, buffer_read_in=32
^ permalink raw reply [nested|flat] 6+ messages in thread
* ODBC-Interfaces - connection options ? Error !
@ 1999-09-20 15:14 Jyry Kuukkanen <jyry@laserle.fi>
0 siblings, 1 reply; 6+ messages in thread
From: Jyry Kuukkanen @ 1999-09-20 15:14 UTC (permalink / raw)
To: pgsql-interfaces
>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.....;
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
@ 1999-09-21 02:46 Nuchanach Klinjun <nuchk@inet.co.th>
parent: Jyry Kuukkanen <jyry@laserle.fi>
0 siblings, 2 replies; 6+ messages in thread
From: Nuchanach Klinjun @ 1999-09-21 02:46 UTC (permalink / raw)
To: Jyry Kuukkanen <jyry@laserle.fi>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
@ 1999-09-22 14:14 marten@feki.toppoint.de
parent: Nuchanach Klinjun <nuchk@inet.co.th>
1 sibling, 1 reply; 6+ messages in thread
From: marten@feki.toppoint.de @ 1999-09-22 14:14 UTC (permalink / raw)
To: nuchk@inet.co.th; +Cc: jyry@laserle.fi; 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)
>
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.
The checking was done within IBM Smalltalk and I´ve found the call, where
the special option has been set. Removing the call and I was able to use
the PostgreSQL driver.
BUT: I´ve 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 !
Marten
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
@ 1999-09-23 02:35 Nuchanach Klinjun <nuchk@inet.co.th>
parent: marten@feki.toppoint.de
0 siblings, 0 replies; 6+ messages in thread
From: Nuchanach Klinjun @ 1999-09-23 02:35 UTC (permalink / raw)
To: marten@feki.toppoint.de; +Cc: jyry@laserle.fi; pgsql-interfaces
On Wed, 22 Sep 1999 marten@feki.toppoint.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 I´ve found the call, where
> the special option has been set. Removing the call and I was able to use
> the PostgreSQL driver.
>
> BUT: I´ve 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@inet.co.th
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [INTERFACES] ODBC-Interfaces - connection options ? Error !
@ 1999-09-25 08:03 Jyry Kuukkanen <jyry@laserle.fi>
parent: Nuchanach Klinjun <nuchk@inet.co.th>
1 sibling, 0 replies; 6+ messages in thread
From: Jyry Kuukkanen @ 1999-09-25 08:03 UTC (permalink / raw)
To: Nuchanach Klinjun <nuchk@inet.co.th>; +Cc: pgsql-interfaces
> > 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
Nothing to check, really. My "plaah" was just foobar to fill the nonsense
part in the log data to save some space in my msg :-)
And still no solution :-(
--Jyry
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~1999-09-25 08:03 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-29 05:50 ODBC-Interfaces - connection options ? Error ! marten@feki.toppoint.de
1999-09-20 15:14 ODBC-Interfaces - connection options ? Error ! Jyry Kuukkanen <jyry@laserle.fi>
1999-09-21 02:46 ` Nuchanach Klinjun <nuchk@inet.co.th>
1999-09-22 14:14 ` marten@feki.toppoint.de
1999-09-23 02:35 ` Nuchanach Klinjun <nuchk@inet.co.th>
1999-09-25 08:03 ` Jyry Kuukkanen <jyry@laserle.fi>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox