Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get to the Oracle system table names with ODBC in Access

Re: How to get to the Oracle system table names with ODBC in Access

From: Andy Hardy <newsjan01_at_ahardy.demon.co.uk>
Date: Wed, 31 Jan 2001 21:59:59 +0000
Message-ID: <qpHI4aAfrIe6EwHA@ahardy.demon.co.uk>

In article <957a1a$5cq$1_at_ih292.ea.unisys.com>, NoSpam <NoSpam_at_NoSpam.com> writes
>I'm using ODBC with MsAccess to read an Oracle system table (something like
>SYS.ALL_ALL_TABLES) in order to get to the DB data dictionary. The ODBC
>connection works all right with other user tables but it just doesn't work
>with system tables. What I'm trying to do is this:
>
>Set rst = dbs.OpenRecordset("SELECT * FROM SYS.ALL_ALL_TABLES",
>dbOpenForwardOnly)
>
>Access ODBC mistakes it as SYS.MDB and reports the table missing. I realize
>the "." is translated to "_" when Access links to an Oracle table. Then I
>use SYS_ALL_ALL_TABLES but it still say "SYS_ALL_ALL_TABLES table not
>found". Just how can I read a system table from Oracle?
>
>
>TIA
>
>
>

Isn't sys.all_tables a view? Doesn't MSAccess/ODBC have a problem with working with anything that doesn't have a primary key e.g. views?

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================
Received on Wed Jan 31 2001 - 15:59:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US