Hello,

I am msssing some table when I use an OLE DB connection to an Oracle
server.

My connecton string is -

'Provider=msdaora;DataSource=MyDataBase;UserId=Use rID;Password=UserPassword;'

I have a structure as soon in my Oracle Enterprise Manager as -

network -
databases

- MyDataBase

- schema

- table

- COMMON

- List Of Table Names

- MYDataBase

- List Of Table Names

- IMPORTANT

- List Of Table Names

When I use the OLE DB connection above I can see everything in
"MyDataBase", but nothing in COMMON or IMPORTANT.

If I make each of them a seperate connection using as DataSource =
MyDatabase another with DataSource = COMMON and another as DataSource
= IMPORTANT I can see the proper tables in MyDatabase, I see no tables
under the COMMON connection, nor any under the IMPORTANT connection.

Thus my question becomes - HOW do I see all the tables located under
each section ?

My linker server in SQL works just fine and I have no problems.
However in this case I need to do some things in the COMMOM and
IMPORTANT sections in ASP.

Any Advice ?

Jon Spartan