How to get ODAC work with ASP.net in VS2010 ?
922688Mar 8 2012 — edited Mar 26 2012I installed ODAC112030_x64.exe ( *64-bit ODAC 11.2 Release 4 (11.2.0.3.0) for Windows x64* ) on my Windows 7 64 bit machine with Visual Studio 2010.
All I'm interested in is connecting my ASP.net application (my localhost) to Oracle 11g server (separate machine) .
During installation of Oracle Universal Installer, I unchecked
"Oracle Developer Tools for Visual Studio 11.2.0.3.0" and "Oracle Services For Microsoft Transaction Server 11.2.0.3.0 ,
because I use TOAD for Oracle development and don't use MTS.
Everything else was checked, including Oracle Data Provider, Oracle Data Access Components, Oracle Client, SQL Plus, etc.
So I have 3 questions :
1. Do I need to have any Oracle-specific dlls in my bin\ folder for ASP.net page to connect to oracle ?
2. How can I get VS2010 to see "Oracle Data Provider for .NET" when I do "Add Connection" ?
3. What should web.config say to establish connection ?
Edited by: 919685 on Mar 8, 2012 12:33 PM
Edited by: 919685 on Mar 8, 2012 12:36 PM