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

Browse pgsql-general by date

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

Browse pgsql-odbc by date

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