Oracle database not connecting on IIS7

I am using asp.net code on II7 and database is Oracle, When I run code through visual studio then database connects properly but when I set code on IIS7 on
windows server 2008 machine then It doesn't get connect, Its get loading and loading page and then get session time out, please help me.
SudhanshumAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
When I run code through visual studio then database connects properly but when I set code on IIS7 on
windows server 2008 machine then It doesn't get connect, Its get loading and loading page and then get session time out

IIS will be used to host your website but it's the codes of your website to connect to database.

few things to check:

1. make sure your Oracle database service is running fine?
2. check the connectionstring setting in web config and make sure it's configured properly.
3. make sure your IIS is running fine > you can surf other static asp.net pages, for example?
4. try to write the asp.net errors into log for debugging. you can use log4net library for this.
0
slightwv (䄆 Netminder) Commented:
Make sure the web server can see the database server.  Typically you don't let web servers connect directly to a database server.  When you do, there should be a firewall between them.  The firewall is likely blocking the connection.
0
SudhanshumAuthor Commented:
I checked that firewall is blocked, I am surprised that its working with visual studio but not with IIS7.
0
slightwv (䄆 Netminder) Commented:
Your workstation likely has a different network path to the database server than a web server.  That and the Network Admins likely know a Developer needs access to the database server and has already opened that up through the Firewall.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.