OLEDB provider for Oracle/Informix
Posted in 1999
Topics: General Discussion
Hello, I am looking for an OLEDB provider for both oracle (7.3.4 or later) and Informix (dyn. server 7.30). For oracle Microsoft supplies an OLEDB provider, but when talking to it using ADO (openschema) it seems like it doesn't support quering the meta for available indexes and primary keys (no adSchemaIndexes). So through the OLEDB provider I should be able to use ADODB.OpenSchema(adSchemaIndexes). Kind regards, Marc Teutelink(mailto:mteutelink@baan.nl)
Intersolve makes an OLEDB provider for informix, and just about every other database. not sure how complete it is I have never used it. Marc Teutelink <mteutelink@baan.nl> wrote in message news:7ffaf1$esd$2@zonnetje.NL.net... > Hello, > > I am looking for an OLEDB provider for both oracle (7.3.4 or later) and > Informix (dyn. server 7.30). > > For oracle Microsoft supplies an OLEDB provider, but when talking to it > using ADO (openschema) it seems like it doesn't support quering the meta for > available indexes and primary keys (no adSchemaIndexes). > > So through the OLEDB provider I should be able to use > ADODB.OpenSchema(adSchemaIndexes). > > Kind regards, > > Marc Teutelink(mailto:mteutelink@baan.nl) > > > > > > > > > > > >