473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Error on ASP page C0000005

Hi,

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

/ict/ta_overview.asp

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

Server object error 'ASP 0177 : c0000005'

Server.CreateObject Failed

/ADO_webcontent.asp, line 21

c0000005

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"),8),5)%>&nbsp;<%=trim
(objRS("ccd_title"))%>","<%response.write(dir)%>/<%=trim(objRS("ccd_filename
"))%>.<%=objRS("ccd_filetype")%>","text");
<%objRS.MoveNext
loop
objRS.close
%>
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, _
adLockBatchOptimistic

' Disconnect the recordset.
Set objRS.ActiveConnection = Nothing

' -- Close the connection
objConn.Close

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

End Function
%>
Hope someone can help, I'm really stuck

TNGgroup

Jul 19 '05 #1
0 2145

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Lokesh | last post by:
Hi All, When i am accessing the website i am getting this error: Active Server Pages error 'ASP 0115' Unexpected error /hradmin/Default.asp
4
by: Ritche | last post by:
I have a redirect page using PerlScript titled clickthru.asp: <%@LANGUAGE="PerlScript"%> <% my $url = $Request->QueryString('url')->Item(); $Response->Redirect($url); %> I keep running into...
2
by: Petar Popara | last post by:
This is from Event Viewer. What is it? Error: Script Engine Exception. A ScriptEngine threw expection 'C0000005' in 'IActiveScript::SetScriptState()' from ...
1
by: szudor | last post by:
Hi, When I start db2cc, the program hangs with memory access violation in javaw.exe. Strating with trace option, in java trace file I found the following information: 0SECTION TITLE...
7
by: Dave Mandy | last post by:
Hi All I have written a C# console based program. The first line of code simply writes to the event log and this works 99% of the time, whether being run manually or kicked off by Windows...
1
by: zb | last post by:
I am writing a C# program that uses MySQL as database and MySQL ODBC 3.51 driver. It works fine all the way except this scenario that needs to be addressed. 1. Get a set of records to process...
0
by: amitpatil | last post by:
I am having trouble with following error. there are few registration page when i register 2 members it works but when i try to create 3rd one i get following error and then for 10 mins or so website...
0
by: chrisexv6 | last post by:
Running a webservice under IIS 5.0, we've recently started seeing COM+ errors in Event Viewer. The details are: Event Type: Error Event Source: COM+ Event Category: SVC Event ID: 4194...
1
by: santosh.anumandla | last post by:
Hi all, I am getting the following error randomly, I cannot expalin the exact scenario Active Server Pages error 'ASP 0115' Unexpected error /wmweb/Save.Asp A trappable error (C0000005)...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.