Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > Oracle ASP
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Oracle ASP Using ASP with Oracle databases. For Oracle discussions not specific to ASP, please see the Oracle forum. For more ASP discussions, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle ASP section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 9th, 2003, 09:35 AM
Registered User
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Lolly
Default Intermittent Execute Error

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
  #2 (permalink)  
Old October 15th, 2003, 07:54 AM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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




  #3 (permalink)  
Old October 23rd, 2003, 12:56 AM
Friend of Wrox
 
Join Date: Oct 2003
Location: colombo, WP, Sri Lanka.
Posts: 481
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via MSN to surendran Send a message via Yahoo to surendran
Default

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
  #4 (permalink)  
Old November 10th, 2003, 05:56 AM
Registered User
 
Join Date: Nov 2003
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

  #5 (permalink)  
Old November 10th, 2003, 06:28 AM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

  #6 (permalink)  
Old November 10th, 2003, 06:32 AM
Registered User
 
Join Date: Nov 2003
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

  #7 (permalink)  
Old November 10th, 2003, 06:43 AM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

  #8 (permalink)  
Old November 14th, 2003, 05:16 PM
Registered User
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Lolly
Default

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.
  #9 (permalink)  
Old November 15th, 2003, 07:53 AM
Registered User
 
Join Date: Nov 2003
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 ;)

  #10 (permalink)  
Old November 18th, 2003, 10:23 AM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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



 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intermittent RSA block problems psearls55 BOOK: Beginning Cryptography with Java 5 July 17th, 2007 07:54 PM
Intermittent Freeze Crystal 8 to White Screen SyraJohn Crystal Reports 4 March 3rd, 2007 11:13 AM
Dell/Intel based NIC Teaming intermittent issue sugar Windows Server 0 November 24th, 2006 06:21 PM
Execute Package Error dgosche BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 2 February 13th, 2006 12:14 PM
objCmd.Execute error Thodoris SQL Server 2000 4 April 26th, 2004 07:20 AM



All times are GMT -4. The time now is 11:35 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.