How to connect Sql DB and Oracle DB? [Archive]

Click to See Complete Forum and Search --> : How to connect Sql DB and Oracle DB?

NinaWilliam

08-30-2005, 01:55 AM

Hi guys,

how can i make my sql database read and store data from Oracle db?
because my system reads data from sql database.. but some data need to be read from oracle and stored in sql database so the system can retrieve them from the sql database..

can anyone help me in this case? i don't know how to connect 2 different databases ...

ASP.NET/VB.NET

Regards,
Nina

Memnoch

08-30-2005, 04:13 PM

You'll need two different connection objects one SqlClient, the other OracleClient.

NinaWilliam

09-13-2005, 01:33 AM

Can you please write the connection string?? ( one example please..)