Problem accessing Personal Oracle7 through Visual Basic

From: Chunangad S. Sriram <ramcssri_at_unm.edu>
Date: Tue, 22 Sep 1998 09:06:15 -0600
Message-ID: <3607BCE6.B8C302DC@unm.edu>

While trying to access Personal Oracle7 with the help of Microsoft's ODBC driver for Oracle from Visual Basic, I encountered the following :

One of the conventional users of Personal Oracle is 'scott'. By using the Personal Oracle Navigator, I found that 'scott' had ownership of tables 'EMP', 'DEPT' etc.. But when I tried to open a database from VB using the MS ODBC driver for Oracle with the owner name as 'Scott', I got to open all the tables (system tables, some of them whose names started with 'PUBLIC') except for those small tables 'EMP', DEPT' which I planned to query with SQL statements.

Could anyone kindly tell me how I can get to open only the non-system tables which I want to perform SQL queries on ?

Sriram Received on Tue Sep 22 1998 - 10:06:15 CDT