Filtering using Oracle OLEDB-BETA-provider NOT possible ?

From: Arjan van Muyen <muyena_at_usoft.nl>
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

Original text of this message