473,326 Members | 2,805 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,326 software developers and data experts.

Is there an easy way to find out If all OBJECTS are closed?

I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.

I've looked through the code and it looks OK.

Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
etc.

TIA
Steve
Jun 27 '08 #1
4 2249
sh***@uaex.edu wrote:
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.

I've looked through the code and it looks OK.

Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
No.
Leaving them open MIGHT cause memory leaks that COULD cause IIS to need
to be restarted, however, this would not impact CreateObject. There is
something else going on.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jun 27 '08 #2
On Apr 30, 9:09 am, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:
sh...@uaex.edu wrote:
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
I've looked through the code and it looks OK.
Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets

No.
Leaving them open MIGHT cause memory leaks that COULD cause IIS to need
to be restarted, however, this would not impact CreateObject. There is
something else going on.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
I have tried to close every Recordset.( I might have missed one)
I'm calling a DLL and it has been working OK.
I've looked through the code twice to make sure that I have

Set oDLL=nothing

Here's the error message( It may appear once every two weeks or
longer)

Error: File /fcsSelectPestMgmt.asp CreateObject Exception. The
CreateObject of '(null)' caused exception C0000005..

It acts as if ,on one day, the DLL becomes unregistered.

I'm running out of clues on how to solve this.

TIA
Steve
Jun 27 '08 #3
sh***@uaex.edu wrote:
On Apr 30, 9:09 am, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:
>sh...@uaex.edu wrote:
>>I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
>>I've looked through the code and it looks OK.
>>Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets

No.
Leaving them open MIGHT cause memory leaks that COULD cause IIS to
need to be restarted, however, this would not impact CreateObject.
There is something else going on.

I have tried to close every Recordset.( I might have missed one)
I'm calling a DLL and it has been working OK.
I've looked through the code twice to make sure that I have

Set oDLL=nothing

Here's the error message( It may appear once every two weeks or
longer)

Error: File /fcsSelectPestMgmt.asp CreateObject Exception. The
CreateObject of '(null)' caused exception C0000005..

It acts as if ,on one day, the DLL becomes unregistered.

I'm running out of clues on how to solve this.
I'm afraid I'm not going to of much help here, except to reiterate that
you are likely chasing a red herring at the moment. Based on my
admittedly faulty memory, a C0000005 exception is not one of the
symptoms caused by failure to close and destroy ADO objects. From
http://tutorials.aspfaq.com/8000xxxx...5-errors.html:

This could be because you are trying to create an ADO recordset object
as a session variable. See http://www.aspfaq.com/show.asp?id=2053 and
http://support.microsoft.com/default.aspx/kb/262681

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jun 27 '08 #4

<sh***@uaex.eduwrote in message
news:96**********************************@x35g2000 hsb.googlegroups.com...
On Apr 30, 9:09 am, "Bob Barrows [MVP]" <reb01...@NOyahoo.SPAMcom>
wrote:
sh...@uaex.edu wrote:
I have several pages ( ASP) that were working OK on NT4.
We moved it to Server 2003. At random , it appears that the
Server.CreateObject fails.
I've looked through the code and it looks OK.
Is there an easy way to make sure I have Closed all
CONNECTIONS
RecordSets
No.
Leaving them open MIGHT cause memory leaks that COULD cause IIS to need
to be restarted, however, this would not impact CreateObject. There is
something else going on.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

I have tried to close every Recordset.( I might have missed one)
I'm calling a DLL and it has been working OK.
I've looked through the code twice to make sure that I have

Set oDLL=nothing

Here's the error message( It may appear once every two weeks or
longer)

Error: File /fcsSelectPestMgmt.asp CreateObject Exception. The
CreateObject of '(null)' caused exception C0000005..

It acts as if ,on one day, the DLL becomes unregistered.

I'm running out of clues on how to solve this.
C0000005 is the classic Access violation error.

All the setting stuff to nothing won't help you solve this (and is
superflous anyway).

The most likely cause is the DLL doing bad things that it got away with on
NT but 2003 is less happy about. One area you should research is Data
Execution Protection some older DLLs would place something the OS considers
to be executable code (usually a vtable) in data memory. Later versions of
windows can block the execution of such code.
--
Anthony Jones - MVP ASP/ASP.NET
Jun 27 '08 #5

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

Similar topics

2
by: Thomas HAMEL | last post by:
Hello, I'm working on an access application, at the opening of the application I create some objects (in order to do this I use the AutoExec action). I want to be sure that these objects are...
1
by: MS | last post by:
When is it appropriate to "close" objects? Example. Which of these objects should be "closed"? Dim Wsp as Workspace Dim Dbf as DataBase Dim Rstb as Recordset Dim Tdf As TableDef Dim Cdb As...
6
by: Jules Winfield | last post by:
I'm loving VS 2005. These are my questions and comments so far: BUG: Autoformatting ================ I've turned off virtually all autoformatting, but there is still one place where it rears...
13
by: Simon Harvey | last post by:
Hi All, I have a colleague that I wprk with that develops using ASP. I develop using ASP.net. He seems to make sites much faster than me and I am wondering if its because of the two different...
16
by: Java script Dude | last post by:
Creating a method of object (Object.prototype.classOf ...) is not the correct way because of a (as expected) flaw in IE where DOM Elements does not inherit from Object. As a result it is best to...
3
by: Terry Hancock | last post by:
Is there an *easy* way to make an object immutable in python? Or perhaps I should say "one obvious way to do it"? Oughtn't there to be one? I've found a thread on how to do this, which...
13
by: Adam Right | last post by:
Hi, I am developing a financial application and you know that there are huge amount of data in these similar aplications. I have a MDIChild form and the other forms are opened in this form. For...
2
by: Steven D'Aprano | last post by:
I have found myself writing functions rather like these: def openfile(filename): if filename == '-': # convention for shell scripts in Unix-land is to use # '-' for stdin/stdout for...
0
by: shall | last post by:
I have several pages ( ASP) that were working OK on NT4. We moved it to Server 2003. At random , it appears that the Server.CreateObject fails. I've looked through the code and it looks OK. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
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
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.