Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection.Open() hangs

user10875959Jan 23 2015 — edited Jan 29 2015

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.

This post has been answered by Wataru Tanabe on Jan 28 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2015
Added on Jan 23 2015
6 comments
4,425 views