Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> How to get to the Oracle system table names with ODBC in Access
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 Tue Jan 30 2001 - 17:22:39 CST