We have a Windows 2008R2 Server with the 64bit Oracle client installed.
I have confirmed it is working and configured properly by creating a test.udl and successfully testing the connection.
Even if I copy the connection string from the test.udl (including user and password info) and paste it into an ASP.Net page when I call myconnection.Open() the page hangs.
Static pages work fine on the web server as do ASP.Net pages that do NOT attempt to connect to a database.
I've verified everything is 64bit (application pool, OS, oracle client).
No error is ever returned. I've tried wrappoing the myconnection.Open() in a try block to no avail. From the browser the page just hangs for MINUTES then eventually you get the standard page cannot be displayed error. I don't know if it's oracle or IIS or what but I'm at a loss with no error message to look up, non-db asp.net pages working fine, and the udl testing successfully.
Any assistance would be greatly appreciated.