Using Oracle-OLEDB-provider to query meta-data

From: arrrjan <muyena_at_usoft.nl>
Date: Wed, 17 Nov 1999 17:53:47 +0100
Message-ID: <80umi9$lf$1@porthos.nl.uu.net>

Hi people,

I am using OLEDB to query meta-data from a database, using MSsqlServer i am successful !
When trying the code on the latest
OLEDB-Provider from Oracle i am run into strange problems.

i found that Orcacle does not support catalogs and schema's.

When filling the restrictions with null (cat-name), userid(schemaname), null (tablename) this gives back a not-supported ! while doing a unrestricted-query gives me the results i want.

BUT, an unrestricted query on an LARGE-database is veryvery timeconsuming

Now i have started to query the vieuws like all_objects etc to get me what i want :: ie coding db-dependant

Does anyone know a solution for me to use OLEDB ?

Tnx
Arjan van Muyen Received on Wed Nov 17 1999 - 10:53:47 CST