I have an .asp page that writes to my Oracle DB, and on one server (WB) it works great, on the other (RT) I receive the following error about 50% of the time:

Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Execute'
/SolutionsT/course_startIns.asp, line 88

The code is fine - I've had several "experts" check it out. And it works fine on the WB server all the time.

I checked the ODBC on both servers, and the only difference I can find is that RT uses the Microsoft ODBC Driver
2.573.7713.00 and WB uses the Microsoft ODBC Driver 2.573.7926.00

I am not sure if this could be causing the problem or not...

The coding reads like this:

dim objSQLDB, rsEDPersons, strSQL, repeat

        Set objSQLDB = Server.CreateObject("ADODB.Connection")
        objSQLDB.Open(MM_STRING)

        strSQL = "Select empid from ED_PERSONS where empid ='" & empid & "'"

        Set rsEDPersons = objSQLDB.Execute(strSQL) //line88

Any ideas??

Lolly


Lolly @hp
Technical Business Analyst

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

this error commimg from service pack and security problem.
add this two permission to that folder: IUSER_**** and IWAM_**** and give Full Control.
i think it will work.

surendran

Hey i got the same problem as you both .. Have you found a solution for that? I am sure that i close all connections and i get the error message too.

it works for some time then the error comes up .. then it works again and then again the error comes. and so on, and so on ...

Please help

Hello Gabru,

We still didn't find any solution.
We have already tried a lot of things like:

* reinstalling ODBC drivers
* reinstalling mysql
* register the asp.dll again
* tracing a lot of things in the dllhost.exe
  * private bytes
  * handles
  * virtual bytes

As far as i can see now the handles (IUSR/IWAM) in the dllhost increase in time and never stop increasing.

A few temporary solutions I found:

* restart the IIS server every .. hours --> I use IIS5recycle


* You can try to run every website under a seperated dllhost.exe,
that way you can see which site is leaking. (didn't work for me)

You can do this according the following steps:

1) open IIS
2) properties of a site
3) home directory
4) application protection --> put this to High (isolated)

Hope this helped.

i got 2 servers. and on one the complete applications works fine with exactly the same code and on the other it doesnt work... i have to find a solution.

We also tried to run applicatons on another server and it also works fine. I indeed think it has something to do with a security problem and IUSR/IWAM.

Please help us

We have not found a real solution yet, luckily our error server is also our test server.... Error handling that we implemented has slowed it down, but not eliminated it.

yeah thats the same here ... the problems are only on testserver. so we have luck ... but i still want to know what it could be ;)

Maybe I found something about the problem:

I tested the following code on a local machine (example):

' query
sql = "select * from table"
set rs = Server.CreateObject("ADODB.RecordSet")
set rs = dbConn_CMS.Execute(sql)

' put into array
dim array_query

' move to the current record
rs.move current_record
array_query = rs.getRows()

' close resultset
rs.close
set rs = nothing

' do something with array

When I move a few times to a record which not exist i get the error:

Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'rs.move'

Now when I keep refreshing this page the error changes into:

Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Execute'

I don't know what this means but maybe you can tell me.
Please try it out and let me know if this has something to do with it...

Thanks