Filtering using Oracle OLEDB-BETA-provider NOT possible ?
Date: Thu, 18 Nov 1999 14:43:43 +0100
Message-ID: <810vpl$qq9$1_at_porthos.nl.uu.net>
[Quoted] 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 [Quoted] 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 [Quoted] does not has permission to see, which of course is the database it's answer.
[Quoted] Or does anybody know a solution for me to use filtering..
Tnx
Arjan Received on Thu Nov 18 1999 - 14:43:43 CET