Received: from bastion.solipsys.com (bastion.solipsys.com [209.117.190.2]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA31423 for ; Fri, 25 Jun 1999 14:39:01 -0400 (EDT) (envelope-from byronn@solipsys.com) Received: from solipsys.com ([209.117.190.166]) by bastion.solipsys.com (8.9.1a/8.9.1) with ESMTP id OAA05035; Fri, 25 Jun 1999 14:35:09 -0400 (EDT) Message-ID: <3773CC36.F2848A72@solipsys.com> Date: Fri, 25 Jun 1999 14:36:39 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.51 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Chay Wesley CC: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables References: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us> Content-Type: multipart/alternative; boundary="------------659EF4022F9FEB2BD5FF2CC4" --------------659EF4022F9FEB2BD5FF2CC4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chay Wesley wrote: > I've recently upgraded both pieces of software (DB, & ODBC), and since > then, I can't browse tables in the DB using the ODBC driver.For > example, open Access 97, use 'Get External Data -> Link Tables -> > ODBC, etc' and when the tables list comes up, it is completely empty. > This even occurs if I have selected 'Show System Tables' in the ODBC > configuration. I have appended the resultant psqlodbc.log file to > the end of this message. As a side note, accessing the database via > JDBC from within NetBeans (on the workstation) seems to work fine, as > does psql on the server. > Other (possibly) relevant info: Workstation: NT Workstation 4.0, > Service Pack 4 Server (i386): RedHat Linux 6.0, Postgres 6.5 Any > ideas/help appreciated.================================ > Chay Wesley (chay@ci.danville.ky.us) > Director of Financial Information Services > City of Danville, Kentucky > http://www.danville-ky.com > http://ci.danville.ky.us psqlodbc.log > :=================================================================================================conn=155203152, > SQLDriverConnect( in)='DSN=JobShop;', fDriverCompletion=1 > DSN info: > DSN='JobShop',server='mis2.ci.danville.ky.us',port='5432',dbase='jobshop',user='postgres',passwd='blablabla' > > > 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=1, ksqo=1, 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=155203152, query=' ' > conn=155203152, query='set DateStyle to 'ISO'' > conn=155203152, query='set geqo to 'OFF'' > conn=155203152, query='set ksqo to 'ON'' > conn=155203152, query='select oid from pg_type where typname='lo'' > [ fetched 0 rows ] > conn=155203152, > SQLDriverConnect(out)='DSN=JobShop;DATABASE=jobshop;SERVER=mis2.ci.danville.ky.us;PORT=5432;UID=postgres;PWD=blablabla;READONLY=1;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=' > > conn=155203152, query='SELECT Config, nValue FROM MSysConf' > ERROR from backend during send_query: 'ERROR: msysconf: Table does > not exist.' > STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error > while executing the query' > > ------------------------------------------------------------ > hdbc=155203152, stmt=155254848, result=0 > manual_result=0, prepare=0, internal=0 > bindings=0, bindings_allocated=0 > parameters=0, parameters_allocated=0 > statement_type=0, statement='SELECT Config, nValue > FROM MSysConf' > stmt_with_params='SELECT Config, nValue FROM > MSysConf' > data_at_exec=-1, current_exec_param=-1, put_data=0 > currTuple=-1, current_col=-1, lobj_fd=-1 > maxRows=0, rowset_size=1, keyset_size=0, > cursor_type=0, scroll_concurrency=1 > cursor_name='SQL_CUR09410040' > ----------------QResult Info > ------------------------------- > CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: > msysconf: Table does not exist.' > > ------------------------------------------------------------ > henv=155197000, conn=155203152, status=1, num_stmts=16 > sock=155197016, stmts=155197064, lobj_type=-999 > ---------------- Socket Info > ------------------------------- > socket=352, reverse=0, errornumber=0, errormsg='(null)' > buffer_in=155209488, buffer_out=155213592 > buffer_filled_in=42, buffer_filled_out=0, > buffer_read_in=42 > conn=155203152, query='select relname, usename, relhasrules from > pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and > int4out(usesysid) = int4out(relowner)order by relname' > [ fetched 0 rows ] > conn=155203152, > SQLDisconnect ==============================================End of > pgsqlodbc.log. The log shows that 0 rows are coming back. Are you sure you have any tables? Try running the exact query above in the psql monitor and see what happens. Byron --------------659EF4022F9FEB2BD5FF2CC4 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit  

Chay Wesley wrote:

I've recently upgraded both pieces of software (DB, & ODBC), and since then, I can't browse tables in the DB using the ODBC driver.For example, open Access 97, use 'Get External Data -> Link Tables -> ODBC, etc' and when the tables list comes up, it is completely empty.  This even occurs if I have selected 'Show System Tables' in the ODBC configuration.  I have appended the resultant  psqlodbc.log file to the end of this message.  As a side note, accessing the database via JDBC from within NetBeans (on the workstation) seems to work fine, as does psql on the server. 
 Other (possibly) relevant info:    Workstation: NT Workstation 4.0, Service Pack 4   Server (i386): RedHat Linux 6.0, Postgres 6.5  Any ideas/help appreciated.================================
Chay Wesley  (chay@ci.danville.ky.us)
Director of Financial Information Services
City of Danville, Kentucky
http://www.danville-ky.com
http://ci.danville.ky.us    psqlodbc.log :=================================================================================================conn=155203152, SQLDriverConnect( in)='DSN=JobShop;', fDriverCompletion=1
DSN info: DSN='JobShop',server='mis2.ci.danville.ky.us',port='5432',dbase='jobshop',user='postgres',passwd='blablabla'
          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=1, ksqo=1, 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=155203152, query=' '
conn=155203152, query='set DateStyle to 'ISO''
conn=155203152, query='set geqo to 'OFF''
conn=155203152, query='set ksqo to 'ON''
conn=155203152, query='select oid from pg_type where typname='lo''
    [ fetched 0 rows ]
conn=155203152, SQLDriverConnect(out)='DSN=JobShop;DATABASE=jobshop;SERVER=mis2.ci.danville.ky.us;PORT=5432;UID=postgres;PWD=blablabla;READONLY=1;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=155203152, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR:  msysconf: Table does not exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=155203152, stmt=155254848, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
                 stmt_with_params='SELECT Config, nValue FROM MSysConf'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR09410040'
                 ----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  msysconf: Table does not exist.'
            ------------------------------------------------------------
            henv=155197000, conn=155203152, status=1, num_stmts=16
            sock=155197016, stmts=155197064, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=352, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=155209488, buffer_out=155213592
            buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=155203152, query='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
    [ fetched 0 rows ]
conn=155203152, SQLDisconnect ==============================================End of pgsqlodbc.log. 


The log shows that 0 rows are coming back.  Are you sure you have any tables?
Try running the exact query above in the psql monitor and see what happens.

Byron --------------659EF4022F9FEB2BD5FF2CC4--