Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Filtering using Oracle OLEDB-BETA-provider NOT possible ?

Re: Filtering using Oracle OLEDB-BETA-provider NOT possible ?

From: Arjan van Muyen <muyena_at_usoft.nl>
Date: Thu, 18 Nov 1999 15:04:39 +0100
Message-ID: <811110$rgg$1@porthos.nl.uu.net>


supplement ::

i work from VB using the openschema-method  :-)

Arjan van Muyen wrote in message <810vpl$qq9$1_at_porthos.nl.uu.net>...
>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 - 08:04:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US