OLEDB PROVIDER DOES NOT CONTAIN THAT TABLE

[tbrauch]

I have an OBDC connection from NT Server to an Oracle database. When I execute a MS SQL query to select from a table on that Oracle database, it says the OLEDB PROVIDER DOES NOT CONTAIN THAT TABLE, but it does. I can, in fact, perform a select on a table in the same Oracle schema ??

Thanks.

 

[foxdev]

Just a guess, but you might need to preface the table with the database name or database+owner name.