Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Active Server Pages error 'ASP 0240'

Posted on 2009-07-07
2
961 Views
Last Modified: 2012-05-07
I am suddenly getting the following error in an ASP page:

A ScriptEngine threw exception 'C0000005' in 'IActiveScript::GetScriptState()' from 'CActiveScriptEngine::ReuseEngine()'.

Happens infrequently after IIS is running for a few days. Restarting IIS service fixes the problem.

This page had been working fine. It uses recordsets to hit a database table. The only thing I have changed is that now the page hits a MySQL database with the ODBC driver rather than SQL Server database table. Nothing else has changed. I put in code to make sure all recordsets were closed because I read that open recordsets could cause this problem. Any ideas?
0
Comment
Question by:mdoolittle
2 Comments
 
LVL 9

Accepted Solution

by:
rg20 earned 500 total points
ID: 24798427
not only close but discarding the object

rs.close
set rs = nothing

may have to switch the lines
0
 

Author Comment

by:mdoolittle
ID: 24798559
we'll see if that works- tx
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question