Microsoft Vbscript Runtime Error '800a01fb' An Exception Occurred 'open'
make sure your IIS works fine. ( please restart the IIS to double check whether it is caused by IIS or not) 3. Which edition ? double check whether the query result is empty or not. 4. set rs_f_get_var = Server.CreateObject("ADODB.Recordset") with rs_f_get_var .ActiveConnection = "dsn=x;uid=x;pwd=x;" .Source = "select var_value from temp_user_vars where unique_id = '" & request.cookies("unique_id") & "' and var_name = '" & s_var & "'" http://vbcity.com/forums/t/96946.aspx
Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process. 4. Let's wait and let you guys know about that. Thank you very much! Adriano Oliveira Thursday, November 13, 2008 10:01 AM Reply | Quote 0 Sign in to vote You miss 100% of the shots you dont take! | Post Points: 5 lmf232 St.
http://www.andrewbuntine.com Reply With Quote 04-29-2005,05:27 PM #5 lmf232s View Profile View Forum Posts Registered User Join Date Jun 2004 Location Kansas City, MO Posts 1,607 well we read the 2 pages so the new connection string looks like this.strConn = "Provider=OraOLEDB.Oracle;User ID=?;Password=?;Data Source=?"Since putting this into place we have not encountered any of the errors mentioned before on the 'open' or 'execute'. at the end always close the recordsets and connections like: RS.Close : set RS = nothing Conn.close : Set Conn = nothing if you are having traffic then upgrade to a If you are a KnowledgePro user, use the Power Search option to find them.
You may have to register before you can post: click the register link above to proceed. Look at your MDAC version. 0 LVL 5 Overall: Level 5 ASP 2 Message Expert Comment by:kcm76 ID: 69135432002-04-02 are u opening and closing the recordset - using the same Query runs fine in Access. 0 LVL 23 Overall: Level 23 Web Development 4 VB Script 3 Message Expert Comment by:Ashish Patel ID: 202831442007-11-14 Try like the sample given below. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ff469d2-2a7a-46a2-be09-b759fcde7afc/800a01fb-an-exception-occurred-execute?forum=sqldataaccess Last edited by dj4uk; Aug 11th, 2003 at 12:32 PM.
You must tell the participants why you wish to do this, and allow for Expert response. Thanks anyway. Accept a Comment As Answer (use the button next to the Expert's name). 2. This is when the problem started to occure.
You may have to register before you can post: click the register link above to proceed. http://www.vbforums.com/showthread.php?257270-ASP-errors-MDAC-problems Do you have the latest version of MDAC? "Does this napkin smell like chloroform?" ...now with SnapFoo! Forum Program Your Site Classic ASP VBScript runtime error '800a01fb' The SitePoint Forums have moved. Advanced Search VBForums Visual Basic ASP, VB Script ASP errors - MDAC problems?
Which instance type (user / server instance) ? have a peek at these guys The websites are setup and work correctly we are just experiencing an intermittent problem with errors from database pages. regards Chandru 0 Message Author Comment by:flexpipe ID: 202831282007-11-14 Line 7 on Conn.Execute. Anyone can help ? 1 45 77d How can I do a Massively massive community reviewing-and-grading site? 7 62 64d ASP Classic - Using Parameterized Queries Article by: Wayne I have
Connect with top rated Experts 17 Experts available now in Live! Modify the report design after the wizard is done to make it look better. Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? check over here Reply With Quote 10-17-03,04:51 #5 booster View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 5 This ain't a friendly http error!!!
Its still mind boggling how for a year in a half, no problems and then suddenly the its raining errors. Web Development Experts Exchange UI/UX Usability Testing Comparison of JS Frameworks: Angular.js vs React.js vs Ember.js Article by: Serhiy Boost your ability to deliver ambitious and competitive web apps by choosing Close the question if the information was not useful to you, but may help others.
Join & Ask a Question Need Help in Real-Time?
When you grade the question less than an A, please comment as to why. double check whether the query result is empty or not. 4. Reply With Quote Quick Navigation ASP Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL What to check: 1.
All rights reserved. This is pretty much it. My database is SQL SERVER and INFORMIX. 0 How your wiki can always stay up-to-date Promoted by Quip, Inc Quip doubles as a “living” wiki and a project management tool that http://goglospex.com/microsoft-vbscript/microsoft-vbscript-runtime-error-800a01fb.html Reply With Quote Aug 11th, 2003,12:32 PM #2 andreys View Profile View Forum Posts Visit Homepage Frenzied Member Join Date Sep 2002 Location Los Angeles Posts 1,615 I think it is
If i restart the IIS after that > all works fine! Reply With Quote 10-31-03,03:22 #6 pe1pbu View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 1 Found this on another search... If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity Novice question on VBScript 8 40 53d Pass through dll 2 42 Here are the errors I am getting: An exception occurred: 'execute' An exception occurred: 'open' The strange thing is that I can usually hit refresh and it will go away.