| Author: Shunmuganathan M 27 Oct 2009 | Member Level: Diamond | Rating:  Points: 2 |
you just add the reference of oragle.
and make all the connection as like Sqlserver
By Nathan
Direction is important than speed
I am following the following Health Tips
http://dotnetspider.com/sites/1048/-Health-Tips-for-Healthy-Wealthy-IT.aspx
|
| Author: Gaurav Arora 27 Oct 2009 | Member Level: Diamond | Rating: Points: 6 |
Niranjan Kumar,
You can follow the same steps as in case when you are using MsSQL. here few more adding points,
While adding Oracle connection strings:
1. You can use Oracle Data Provider for .NET / ODP.NET
Namespace: Oracle.DataAccess.Client.OracleConnection
Connection string ; Data Source=TORCL;User Id=myUsername;Password=myPassword;
2. You can use .NET Framework Data Provider for ODBC
Namespace:System.Data.Odbc.OdbcConnection
Connection string : Driver={Oracle in OraHome92};Server=myServerAddress;Dbq=myDataBase;Uid=myUsername;Pwd=myPassword;
There are lot more but i am not going to in details.
Thanks & regards,
Gaurav Arora - Sr. Editor
Me in My Own Style
|