Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
php95saj
Starting Member
43 Posts |
 Posted - 2002-05-29 : 09:34:33
|
| Has anyone experienced an "Unexpected Error" that would stop the website, sometimes it would act in such a way that database connection would be lost and would not be recovered again unless the server restarted.The page will throw an error like this:error 'ASP 0115' Unexpected error /admin/admUserLoginLogs.asp A trappable error occurred in an external object. The script cannot continue running. Server object error 'ASP 0115 : 8000ffff' Unexpected error G:\..\..\ADMIN\../modules/vb/db_open.asp, line 4 A trappable error occurred in an external object. The script cannot continue running. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-29 : 10:06:17
|
HiIt generally means you have a buggy component that has hung somewhere. When you say :quote:
database connection would be lost and would not be recovered again unless the server restarted
do you mean that you have an application scoped connection object ? Coz if you do, you are doing ASP all wrong and you will have lots of problemsDamian |
 |
|
|
php95saj
Starting Member
43 Posts |
Posted - 2002-05-29 : 10:10:59
|
| No I am not using application scope connection object but but I get error which says that the unexpected error occured in db_open.asp (below, on line 2)<% Dim objConn, objCmd, objParams Set objConn = Server.CreateObject("ADODB.Connection") Set objCmd = Server.CreateObject("ADODB.Command") objConn.Open Application("database_dsn"), Application("database_user"), Application("database_pwd") objCmd.ActiveConnection = objConn Set objParams = objCmd.Parameters%>not sure why. On other occasions it simply says 'unexpected error' occured.THanks. |
|
|
|
|
|
|
ASP Unexpected Error