ASP.Net application not seeing database?

P

POL8985

The application is built using ASP.Net in VS.Net 2003 and uses a SQL
server database.

About three times a day, the ASP.Net application fail to see the
database, yet it will throw no errors. This results in users not being
able to log in (they receive invalid user/password messages generated
by the application). Additionally, because the application validates
user entries against the SQL Server database, each transaction a user
attempts to perform will fail.

What's strange is from the IIS server which hosts the application, I
can use Query Analyzer to get into the DB!

The quickest way to resolve this has been to re-compile the SLN in
VS.Net 2003 and copy everything over to the production \bin folder.

Does anyone have any ideas? This is a huge problem when 20+ users need
to log off and log back on three times a day.

Thanks:

Pat
 
C

Curt_C [MVP]

sounds like the recompile/copy is simply resetting the app, or rather
restarting it.
What OS? 2003? try restarting the app pool if it is, just to see if that
fixes it.
There may be something with connections, pooling, not closing, etc, that may
be the source as well.
You say you dont get any error at all though huh? are you doing any
overriding to stop the error from showing?
 
P

POL8985

The OS is Windows 2000 Server.

If the problem is with the connections, why would it affect the whole
application? Also, after some random amount of time, the connection to
the SQL Server is finally made again.

I am handling the errors in the behind-the-code for the page. However,
some run-time errors actually do show up, essentially by-passing the
CATCH statement.

My connections are being closed after they're used in a FINALLY
statement. Do you think other processes occuring on this server might
be affecting my application?

Pat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top