Filtering using Oracle OLEDB-BETA-provider NOT possible ?

Hello OLEDB-user,

I am using OLEDB to query metadata from the database. Using the MSsqlserver-provider, my implementation is successful. When testing it on the oracle-beta driver on a oracle 7.3 database i cannot use criteria to specify e.g that i only want tables from a specific user (schema). The driver gives back a "not supported"

When I NOT specify any criteria, it gives back data (way too much (loads of synonyms e.d.), and with a unacceptable low performance) however, i only see tables that belong to me

for me it looks like you cannot specify any criteria to filter your results and that the driver spends 90% of its time asking the databse for objects it does not has permission to see, which of course is the database it's answer.

Or does anybody know a solution for me to use filtering..

Tnx

Arjan Received on Thu Nov 18 1999 - 07:43:43 CST