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

From: Eric Givler <egivler_at_flash.net>
Date: Wed, 31 Jan 2001 15:44:05 GMT
Message-ID: <9pWd6.3960$Nq6.170150@news.flash.net>

have you tried accessing it via a private synonym for the underlying object, or a public synonym that only your account has access to?

"NoSpam" <NoSpam_at_NoSpam.com> wrote in message news:957a1a$5cq$1_at_ih292.ea.unisys.com...
> 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
>
>
>
Received on Wed Jan 31 2001 - 09:44:05 CST