Hello,
I am assuming that when you say from SQL Server 2005 to Oracle means you want your ASP.NET application to connect to Oracle Databse instead of SQL Server 2005. If this is correct assumption then please go ahead and read the remaing part of the solution.
Insted of using ODBC driver install Oracle Data Provider For Net (ODP.NET) available from here[
^]. The installation guide can be found here [
^]. Once it's installed check whether the PATH environment variable is uptodate. This can be done by opening command prompt and from C:\> type sqlplus.exe. If PATH is set you should see following response.
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 22 12:46:44 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name:
Press Ctrl+C to stop SQLPlus.exe. You can now connect to Oracle Database using ODP.NET.
Before proceeding further you may want to refer to this article[
^] and ensure that you have written your code in provider independent manner. If not then follow the MSDN article and make appropriate changes to your code. You may also find this[
^] article very useful.
The last change will be to actually add reference to ODP.NET provider in your project. Use connection string similar to one shown below to establish connection to Oracle Database from your application.
User Id=YOUR_USER;Password=YOUR_PASSWORD;Data Source=//HOST:PORT/SERVICE_NAME
Please refer to following articles to know more about Oracle Connection Strings.
Regards,