I get this error when I run my asp script:

Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'Execute'

I know it has something to do with:

- IIS: When I do an unload or restart everything is oke for a while
- MDAC: I already tried reinstalling the MDAC
- ODBC: I have installed another ODBC driver but did also didn't work
- Closing Recordsets: I closed all my recordsets.

Can someone please help me with this problem???

Thank you

What's your asp code?

It happens when i execute a query like this for example:

connection.Execute("select * from database_table")

For a while everything is oke, but then suddenly this execute error raises.

If you are using IE make sure you turn off 'Show friendly HTTP error messages'.

You will find it under Tools->Internet Options-> Advanced.

By do this and then regenerating the error you will hopefully get a better error message than the one described.


Hope this helps...

This ain't a friendly http error!!!

And the problem is not with my asp/mysql because on another server erverything works ok. The problem lies within IIS I think. Because after a restart/unload of IIS everything works ok again for a while.

What I want to know if someone else had this error and what they did to solve this problem.

Thanks.

Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'GetEnhWMF'
This problem occurs after performing the latest security updates and service packs on some operating systems including Windows XP and Windows 2000 Professional.

Solution(s):


The problem only occurs when you do not specify the HEIGHT and WIDTH parameters. For example, http://localhost/idalin.asp?BARCODE=123456 causes this error,
and
http://localhost/idalin.asp?BARCODE=...T=80&WIDTH=200 allows the server to create the correct barcode.

To solve the problem, you can specify the HEIGHT and WIDTH parameters in pixels for the resulting image or upgrade your package. The latest package of the ASP Server Component for IIS solves the problem and was released January 2003.


Found at http://www.idautomation.com/kb/http500error2.html

Thanks all for your replies.

I think the problem has nothing to do with:

Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'GetEnhWMF'

The problem occurs when I execute a query:

Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'Execute'


This happens after a while. When I restart IIS everything works fine for a while and then the error starts again.

I thinks the problem lies with DLLHOST.EXE:

My private bytes and handles increase and never stop increasing.

In the handles i have a lot of:

* Threads
* Token --> IUSR
* Event --> empty

I hope you can help me with this, thank you!