Received: from mis.ci.danville.ky.us (mis.ci.danville.ky.US [206.28.39.170]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA11128 for ; Fri, 25 Jun 1999 10:08:28 -0400 (EDT) (envelope-from chay@ci.danville.ky.us) Received: from chaywesley (chaywesley.ci.danville.ky.us [192.168.1.99]) by mis.ci.danville.ky.us (8.9.1/8.9.1) with SMTP id JAA14388 for ; Fri, 25 Jun 1999 09:55:56 -0400 Message-ID: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us> From: "Chay Wesley" To: Subject: ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables Date: Fri, 25 Jun 1999 10:08:30 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01BEBEF2.ACF56900" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_0045_01BEBEF2.ACF56900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 =20 =20 Any ideas/help appreciated. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D 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 =20 =20 =20 =20 psqlodbc.log : =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D conn=3D155203152, SQLDriverConnect( in)=3D'DSN=3DJobShop;', = fDriverCompletion=3D1 DSN info: = DSN=3D'JobShop',server=3D'mis2.ci.danville.ky.us',port=3D'5432',dbase=3D'= jobshop',user=3D'postgres',passwd=3D'blablabla' = readonly=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0006', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D8190 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D155203152, query=3D' ' conn=3D155203152, query=3D'set DateStyle to 'ISO'' conn=3D155203152, query=3D'set geqo to 'OFF'' conn=3D155203152, query=3D'set ksqo to 'ON'' conn=3D155203152, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D155203152, = SQLDriverConnect(out)=3D'DSN=3DJobShop;DATABASE=3Djobshop;SERVER=3Dmis2.c= i.danville.ky.us;PORT=3D5432;UID=3Dpostgres;PWD=3Dblablabla;READONLY=3D1;= PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWS= YSTEMTABLES=3D0;CONNSETTINGS=3D' conn=3D155203152, query=3D'SELECT Config, nValue FROM MSysConf' ERROR from backend during send_query: 'ERROR: msysconf: Table does not = exist.' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D1, = errmsg=3D'Error while executing the query' = ------------------------------------------------------------ hdbc=3D155203152, stmt=3D155254848, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D0, statement=3D'SELECT Config, nValue = FROM MSysConf' stmt_with_params=3D'SELECT Config, nValue FROM = MSysConf' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR09410040' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR: = msysconf: Table does not exist.' ------------------------------------------------------------ henv=3D155197000, conn=3D155203152, status=3D1, = num_stmts=3D16 sock=3D155197016, stmts=3D155197064, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D352, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D155209488, buffer_out=3D155213592 buffer_filled_in=3D42, buffer_filled_out=3D0, = buffer_read_in=3D42 conn=3D155203152, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 0 rows ] conn=3D155203152, SQLDisconnect =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D End of pgsqlodbc.log. ------=_NextPart_000_0045_01BEBEF2.ACF56900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I've recently upgraded both pieces of = software (DB,=20 & ODBC), and since then, I can't browse tables in the DB using the = ODBC=20 driver.
For example, open Access 97, use 'Get = External Data=20 -> Link Tables -> ODBC, etc' and when the tables list comes up, it = is=20 completely empty.  This even occurs if I have selected 'Show System = Tables'=20 in the ODBC configuration.  I have appended the resultant =20 psqlodbc.log file to the end of this message.  As a side note, = accessing=20 the database via JDBC from within NetBeans (on the workstation) seems to = work=20 fine, as does psql on the server.
 
Other (possibly) relevant = info:
    Workstation: NT = Workstation 4.0,=20 Service Pack 4
   Server (i386): RedHat = Linux 6.0,=20 Postgres 6.5
 
 
Any ideas/help = appreciated.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Chay=20 Wesley  (chay@ci.danville.ky.us)
Dir= ector of=20 Financial Information Services
City of Danville, Kentucky
http://www.danville-ky.com
http://ci.danville.ky.us
=
 
 
 
 
psqlodbc.log :
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
conn=3D155203152, SQLDriverConnect(=20 in)=3D'DSN=3DJobShop;', fDriverCompletion=3D1
DSN info:=20 DSN=3D'JobShop',server=3D'mis2.ci.danville.ky.us',port=3D'5432',dbase=3D'= jobshop',user=3D'postgres',passwd=3D'blablabla'
   &nbs= p;     =20 readonly=3D'1',protocol=3D'6.4',showoid=3D'0',fakeoidindex=3D'0',showsyst= able=3D'0'
         =20 conn_settings=3D''
        &nb= sp;=20 translation_dll=3D'',translation_option=3D''
Global Options:=20 Version=3D'06.40.0006', fetch=3D100, socket=3D4096, unknown_sizes=3D0,=20 max_varchar_size=3D254,=20 max_longvarchar_size=3D8190
       =         =20 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0,=20 use_declarefetch=3D0
        &= nbsp;      =20 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0,=20 bools_as_char=3D1
        &nbs= p;      =20 extra_systable_prefixes=3D'dd_;', = conn_settings=3D''
conn=3D155203152, query=3D'=20 '
conn=3D155203152, query=3D'set DateStyle to = 'ISO''
conn=3D155203152,=20 query=3D'set geqo to 'OFF''
conn=3D155203152, query=3D'set ksqo to=20 'ON''
conn=3D155203152, query=3D'select oid from pg_type where=20 typname=3D'lo''
    [ fetched 0 rows = ]
conn=3D155203152,=20 SQLDriverConnect(out)=3D'DSN=3DJobShop;DATABASE=3Djobshop;SERVER=3Dmis2.c= i.danville.ky.us;PORT=3D5432;UID=3Dpostgres;PWD=3Dblablabla;READONLY=3D1;= PROTOCOL=3D6.4;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING=3D0;SHOWS= YSTEMTABLES=3D0;CONNSETTINGS=3D'
conn=3D155203152,=20 query=3D'SELECT Config, nValue FROM MSysConf'
ERROR from backend = during=20 send_query: 'ERROR:  msysconf: Table does not exist.'
STATEMENT = ERROR:=20 func=3DSC_execute, desc=3D'', errnum=3D1, errmsg=3D'Error while = executing the=20 query'
          &nb= sp;     =20 ------------------------------------------------------------
 &nb= sp;           &nbs= p;  =20 hdbc=3D155203152, stmt=3D155254848,=20 result=3D0
          = ;      =20 manual_result=3D0, prepare=3D0,=20 internal=3D0
         &nb= sp;      =20 bindings=3D0,=20 bindings_allocated=3D0
        = ;        =20 parameters=3D0,=20 parameters_allocated=3D0
       &nb= sp;        =20 statement_type=3D0, statement=3D'SELECT Config, nValue FROM=20 MSysConf'
          =       =20 stmt_with_params=3D'SELECT Config, nValue FROM=20 MSysConf'
          =       =20 data_at_exec=3D-1, current_exec_param=3D-1,=20 put_data=3D0
         &nb= sp;      =20 currTuple=3D-1, current_col=3D-1,=20 lobj_fd=3D-1
         &nb= sp;      =20 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, cursor_type=3D0,=20 scroll_concurrency=3D1
        = ;        =20 cursor_name=3D'SQL_CUR09410040'
      &n= bsp;         =20 ----------------QResult Info -------------------------------
CONN = ERROR:=20 func=3DSC_execute, desc=3D'', errnum=3D110, errmsg=3D'ERROR:  = msysconf: Table does=20 not=20 exist.'
          &n= bsp;=20 ------------------------------------------------------------
 &nb= sp;         =20 henv=3D155197000, conn=3D155203152, status=3D1,=20 num_stmts=3D16
         &= nbsp; =20 sock=3D155197016, stmts=3D155197064,=20 lobj_type=3D-999
         = ;  =20 ---------------- Socket Info=20 -------------------------------
      &n= bsp;    =20 socket=3D352, reverse=3D0, errornumber=3D0,=20 errormsg=3D'(null)'
        &n= bsp;  =20 buffer_in=3D155209488,=20 buffer_out=3D155213592
        = ;   =20 buffer_filled_in=3D42, buffer_filled_out=3D0, = buffer_read_in=3D42
conn=3D155203152,=20 query=3D'select relname, usename, relhasrules from pg_class, pg_user = where relkind=20 =3D 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =3D=20 int4out(relowner)order by relname'
    [ fetched 0 = rows=20 ]
conn=3D155203152, SQLDisconnect
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<= /FONT>
End of pgsqlodbc.log.
 
------=_NextPart_000_0045_01BEBEF2.ACF56900--