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,
NinaYou'll need two different connection objects one SqlClient, the other OracleClient.Can you please write the connection string?? ( one example please..)
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,
NinaYou'll need two different connection objects one SqlClient, the other OracleClient.Can you please write the connection string?? ( one example please..)