[amitbhavsar]

Hi !

Is it possbile to enable both Microsoft OLE DB Provider for Oracle
and Oracle Provider for OLE DB on a single machine.

here with me , if i make Oracle Provide to run , Microsoft cannot connect and if i make Micorsoft provider to run , oracle provider stops connecting to database server....

has anybody idea why is it so and let me know if there is a work around for this.

Regards ...

Amit Bhavsar
=========

[nightrider]

In VB 6.0 when I use this code, it works OK so try.I believe that help you
Conn.Open "Provider=MSDORA.1;Data Source=YourServer;" & _
"DNS=Pubs;User Id=sa;Password=;"
That is for Oracle, if you want to do it with Microsoft driver, you have to change Provider and DNS.
Also, you have to create DNS in File DNS for each driver.

[amitbhavsar]

Originally posted by nightrider
In VB 6.0 when I use this code, it works OK so try.I believe that help you
Conn.Open "Provider=MSDORA.1;Data Source=YourServer;" & _
"DNS=Pubs;User Id=sa;Password=;"
That is for Oracle, if you want to do it with Microsoft driver, you have to change Provider and DNS.
Also, you have to create DNS in File DNS for each driver.

what u r talking @ is microsoft driver. MSDAORA is from microsoft. and what the problem with me is while developing connectionstring in visual basic IDE for adocn1 , i can connect to microsoft and not oracle one. in fact i cannot make it connect for both the providers on a single machine.

[nightrider]

Originally posted by amitbhavsar
what u r talking @ is microsoft driver. MSDAORA is from microsoft. and what the problem with me is while developing connectionstring in visual basic IDE for adocn1 , i can connect to microsoft and not oracle one. in fact i cannot make it connect for both the providers on a single machine.

Like I wrote you, I used providers MSDORA and OraOLEDB.Oracle.1 on a single machine both at the same time.
If you get error number 430 then you have to instll some patches which you can find on microsoft pages.