Re: Using Oracle-OLEDB-provider to query meta-data

Arrjan,

You did not mention whether or not you are using the .OpenSchema method of the ADO Connection object. It will bring back metadata from your connection object without requiring the developer to know anything about the metadata schema of the DBMS (I need this - I work on too many DBMS's to learn all of their stinkin' system tables!)

If you are not using it, you should certainly check it out. The MSDN documentation for this method is not so great, but the method is really cool. It will return various recordsets of metadata based on the parameters you pass to it. I've used it fairly extensively with Jet and SQLServer OLEDB providers and it works great. I tried it out at a client's Oracle site using the MS OLEDB server for Oracle and it worked - at least for simple things like views and tables.

Maybe you were already using .OpenSchema - if so my apologies for telling you about something you already knew. If not, you should try it out and see if it can get the metadata you need and filter it appropriately to provide adequate performance.

good luck!
Steve Fritts

arrrjan wrote in message <80umi9$lf$1_at_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 - 14:23:59 CST