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

Re: ODBC PG error

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: "Kenneth R(dot) Martinek" <kmartinek(at)livewire(dot)tv>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC PG error
Date: 2001-07-25 00:57:45
Message-ID: 3B5E1989.84D93EB@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Can you turn on ODBC trace and see the output ?

"Kenneth R. Martinek" wrote:
> 
> Hello all,
> 
> Dealing with a lagacy app here (one 'Lotus Approach'), I get an arror
> when I try to open a table:
> 
> conn=45809784, SQLDriverConnect( in)='DSN=pg;', fDriverCompletion=3
> DSN info:
> DSN='pg',server='172.25.208.26',port='5432',dbase='chermox',user='chermox',passwd='password'
> 
> onlyread='0',protocol='6.4',showoid='1',fakeoidindex='0',showsystable='0'
> 
>           conn_settings=''
>           translation_dll='',translation_option=''
> Global Options: Version='07.01.0005', fetch=100, socket=4096,
> unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
>                 disable_optimizer=1, ksqo=1, unique_index=0,
> use_declarefetch=0
>                 text_as_longvarchar=1, unknowns_as_longvarchar=0,
> bools_as_char=1
>                 extra_systable_prefixes='pgadmin_;', conn_settings=''
> conn=45809784, query=' '
> conn=45809784, query='set DateStyle to 'ISO''
> conn=45809784, query='set geqo to 'OFF''
> conn=45809784, query='set ksqo to 'ON''
> conn=45809784, query='select oid from pg_type where typname='lo''
>     [ fetched 0 rows ]
> conn=45809784, query='select version()'
>     [ fetched 1 rows ]
>     [ PostgreSQL version string = 'PostgreSQL 7.1 on i686-pc-linux-gnu,
> compiled by GCC egcs-2.91.66' ]
>     [ PostgreSQL version number = '7.1' ]
> conn=45809784,
> SQLDriverConnect(out)='DSN=pg;DATABASE=chermox;SERVER=172.25.208.26;PORT=5432;UID=chermox;PWD=password;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
> 
> CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041,
> vParam=9874924', errnum=205, errmsg='Unknown connect option (Set)'
>             ------------------------------------------------------------
> 
>             henv=46925008, conn=45809784, status=1, num_stmts=16
>             sock=46925024, stmts=46925072, lobj_type=-999
>             ---------------- Socket Info -------------------------------
> 
>             socket=63, reverse=0, errornumber=0, errormsg='(NULL)'
>             buffer_in=45816252, buffer_out=45820352
>             buffer_filled_in=108, buffer_filled_out=0,
> buffer_read_in=107
> conn=45824452, SQLDriverConnect(
> in)='DSN=pg;UID=chermox;PWD=password;DATABASE=chermox;SERVER=172.25.208.26;PORT=5432;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;',
> fDriverCompletion=0
> DSN info:
> DSN='pg',server='172.25.208.26',port='5432',dbase='chermox',user='chermox',passwd='password'
> 
> onlyread='0',protocol='6.4',showoid='1',fakeoidindex='0',showsystable='0'
> 
>           conn_settings=''
>           translation_dll='',translation_option=''
> Global Options: Version='07.01.0005', fetch=100, socket=4096,
> unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
>                 disable_optimizer=1, ksqo=1, unique_index=0,
> use_declarefetch=0
>                 text_as_longvarchar=1, unknowns_as_longvarchar=0,
> bools_as_char=1
>                 extra_systable_prefixes='pgadmin_;', conn_settings=''
> conn=45824452, query=' '
> conn=45824452, query='set DateStyle to 'ISO''
> conn=45824452, query='set geqo to 'OFF''
> conn=45824452, query='set ksqo to 'ON''
> conn=45824452, query='select oid from pg_type where typname='lo''
>     [ fetched 0 rows ]
> conn=45824452, query='select version()'
>     [ fetched 1 rows ]
>     [ PostgreSQL version string = 'PostgreSQL 7.1 on i686-pc-linux-gnu,
> compiled by GCC egcs-2.91.66' ]
>     [ PostgreSQL version number = '7.1' ]
> conn=45824452,
> SQLDriverConnect(out)='DSN=pg;DATABASE=chermox;SERVER=172.25.208.26;PORT=5432;UID=chermox;PWD=password;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
> 
> CONN ERROR: func=SQLSetConnectOption, desc='fOption=1041,
> vParam=9874924', errnum=205, errmsg='Unknown connect option (Set)'
>             ------------------------------------------------------------
> 
>             henv=46925008, conn=45824452, status=1, num_stmts=16
>             sock=46927296, stmts=46927344, lobj_type=-999
>             ---------------- Socket Info -------------------------------
> 
>             socket=64, reverse=0, errornumber=0, errormsg='(NULL)'
>             buffer_in=45830920, buffer_out=45835020
>             buffer_filled_in=108, buffer_filled_out=0,
> buffer_read_in=107
> conn=45809784, query='select relname, usename, relkind from pg_class,
> pg_user where relkind in ('r', 'v') and relname !~ '^pg_|^pgadmin_' and
> usesysid = relowner order by relname'
>     [ fetched 34 rows ]
> conn=45809784, query='select relname, usename, relkind from pg_class,
> pg_user where relkind in ('r', 'v') and relname like 'bbs' and relname
> !~ '^pg_|^pgadmin_' and usesysid = relowner order by relname'
>     [ fetched 1 rows ]
> conn=45809784, query='select relname, usename, relkind from pg_class,
> pg_user where relkind in ('r', 'v') and relname like 'phonlist' and
> relname !~ '^pg_|^pgadmin_' and usesysid = relowner order by relname'
>     [ fetched 1 rows ]
> conn=45809784, query='select relname, usename, relkind from pg_class,
> pg_user where relkind in ('r', 'v') and relname like 'phonlist' and
> relname !~ '^pg_|^pgadmin_' and usesysid = relowner order by relname'
>     [ fetched 1 rows ]
> conn=45824452, SQLDisconnect
> conn=45809784, SQLDisconnect
> 
> The affore mentioned app works fine woth other ODBC data sources,
> including (a soon to be legacy) MYSQL-ODBC.
> 
> Any ideas would be REALLY appreciated.
> 
> Thanks,
> Ken Martinek

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-07-26 07:44:38
Subject: RE: ODBC PG error
Previous:From: charlie derrDate: 2001-07-24 14:05:26
Subject: Re: Filemaker and pgsql

pgsql-general by date

Next:From: will trillichDate: 2001-07-25 05:07:59
Subject: automating insert-or-select
Previous:From: Tom LaneDate: 2001-07-25 00:30:55
Subject: Re: Re: When PostgreSQL compliant JDBC 2.0?

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