Re: ODBC PG error - Mailing list 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