Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Error on ASP page C0000005

Thread Tools

Error on ASP page C0000005

Posts: n/a

Im trying to build some simple ASP Pages for our Intranet, I'm not a
developer.. just try to do the best I can. for several days everything works
great until this morning, on all my ASP pages I get this Error messages.

Active Server Pages error 'ASP 0241'

CreateObject Exception


The CreateObject of '(null)' caused exception C0000005.

Server object error 'ASP 0177 : c0000005'

Server.CreateObject Failed

/ADO_webcontent.asp, line 21


My search on the net, learned me that this is possible, if I not closed the
connection object properly, now just before this error, I created a page on
friday, where is use this piece of code 9 times in one ASP page (because the
select statement is always different..) is is possible that this is causing
the errors ??

<%strSQL = "SELECT * FROM ccd where left(ccd_filename,3) = 'sop' and
ccd_generalPol = 1"
Set objRS = GetRecordset(strConnection, strSQL)%>
<%do WHILE NOT objRS.EOF%>

GeneralPol.addItem("<%=left(right(objRS("ccd_filen ame"),,5)%>&nbsp;<%=trim

This is my connection file which is included in each ASP file.

' FILE: ADORoutines.asp
' COMMON Include file containing ADO related routines
' Function: GetRecordSet
' Given a valid Connection String and a Valid SQL Statement, this
' Function returns a Disconnected Recordset
Function GetRecordSet(byval strConnectionString, byval strSQL)

dim MdbFilePath
const adUseClient = 3
const adOpenForwardOnly = 0
const adLockBatchOptimistic = 4

' Create instance of connection object and then open the
' connection.
Dim objConn, objRS

Set objConn = Server.CreateObject("ADODB.Connection")
strConnection =
"dsn=SQLConnect_Inventaris;uid=sa;pwd=pwd;DATABASE =be;APP=ASP Script"

objConn.Open strConnection

' Create instance of recordset object and open the
' recordset object against a table.
Set objRS = Server.CreateObject("ADODB.Recordset")

' Setting the cursor location to client side is important
' to get a disconnected recordset.
objRS.CursorLocation = adUseClient
objRS.Open strSQL, _
objConn, _
adOpenForwardOnly, _

' Disconnect the recordset.
Set objRS.ActiveConnection = Nothing

' -- Close the connection

set objConn = Nothing
' -- return the recordset
Set GetRecordSet = objRS

End Function

Hope someone can help, I'm really stuck


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ScriptEngine threw exception 'C0000005' David Lozzi ASP General 0 08-23-2005 12:40 PM
Createobject of '(null)' caused exception C0000005 wk6pack ASP General 14 09-29-2004 11:14 PM
asp submitted to process asp;but calling asp page says:"Page not found" aftr 1hr Divya ASP General 2 05-11-2004 09:07 AM
Exception C0000005 Errors in Scripting Engine Som ASP General 2 03-06-2004 06:51 PM
Calling a html page from an asp page then returning to the next statement on the original asp page Chuck ASP General 0 07-05-2003 02:00 AM