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
  #11 (permalink)  
Old November 18th, 2003, 10:42 AM
Registered User
 
Join Date: Oct 2003
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Oke here I am again:

According the above error i tried to change my connectionstring into:

strConnection =
    "driver={MySQL};" &_
    "server=localhost;" &_
    "uid=root;" &_
    "pwd=pwd;" &_
    "database=database;
    "option=16387" <-- added this line to the connectionstring

Maybe you can try this also.

Thanks

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

thanks i will try that if i will get the error again ... because once i restarted the iis and since then everything works fine ..

  #13 (permalink)  
Old January 21st, 2004, 03:43 PM
Registered User
 
Join Date: Jan 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi...,

I have the same problem. I already try to reinstall MDAC ans ODBC driver...etc, and the intermitent problem persist..., can someone help me please...!!! Thanks...

  #14 (permalink)  
Old February 26th, 2004, 02:05 PM
Registered User
 
Join Date: Feb 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having the exact same errors dealing with a DB2 database. If anyone's solved this, please post.

  #15 (permalink)  
Old February 27th, 2004, 06:36 AM
Registered User
 
Join Date: Feb 2004
Location: Mumbai, Maharashtra, India.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to dpmatrix Send a message via Yahoo to dpmatrix
Default

I think it can happen when you are try to use EmpId in single quotes.
Oracle don't like numeric ids treated like varchar2. It had created problems for me in asp application. Never Select or Update a record without using CLng when the field is numeric field as in this question.
I have faced a serious problem of this kind, in production, but resolved it afterwards.

  #16 (permalink)  
Old June 6th, 2004, 08:03 AM
Registered User
 
Join Date: Jun 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi @ all,

we get the same error msg from a web server (IIS) since some days (sporadically) without using any database connection but performing xslt transformation on xml documents via msxml4.

So I think, the error isn't caused directly by db connections nor msxml but a layer below used by both.

It looks like the sometimes occuring w2k problem that after closing of files or other objects an immediate open / create fails because of "already open", "in use", or other "cannots".

We'll go on for checking the user/iis/security settings. Thanks for the hints.

  #17 (permalink)  
Old June 15th, 2004, 05:45 AM
Registered User
 
Join Date: Jun 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

We have had a similar problem - intermittent 0x800A01F error on some servers and not other.

I have a theory why these are occurring, which we are currently testing, which I would appreciate comment on from others:-

In a number of place we have while loops displaying rows from a recordset, and the RS is only closed once the full list is displayed. Maybe an ethusiastic user is selecting a link from the list and stopping the complete load of the page.

We are trying two things.

1) Using the readyState for the document, to see if the load is "complete" before allowing the user to select.
e.g.
if (document.readyState == "complete")
{
    url = "<%=Application("AppDirVir")%>";
    url += "lookup/prepostsel.asp";
    url += "?PostNo=" + escape(value);
    url += "&Mode=" + escape("<%=CStr(inMode)%>");
    BusyLookingUp(url);

    Closing = false;
    NotifyClose();
}
else
{
    alert("Please wait for the full list to be loaded before making a selection");
}


2) Building the list in a buffer and only displaying the list once all rows are in the buffer with a response write. This works, but can result in a blank screen for a while which isn't very user friendly - has any-one some handy javascript for a nice loading message?


Let me know what you think
Christine
  #18 (permalink)  
Old July 1st, 2004, 01:57 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi!
We have exactly the same problem, with Windows 2000 SP4, MDAC 2.8 and Mssql server.
We have tried with all the options of the IIS.
We have converted some very visited ASP pages to .HTML
We have re-written connection strings, and so on.

And the problem goes on.
We are nearly crazy.
The W2000 log does not help a lot.
The IIS crashes and we have to reinitiate it each two-three hours.

Any help?
Thanks a log.

  #19 (permalink)  
Old July 7th, 2004, 09:25 PM
Registered User
 
Join Date: Jul 2004
Location: , , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Microsoft VBScript runtime error '800a01fb'

I know where this problem is coming from.

I have a unique set of servers available to me, one of them is being used for prototyping only, and only one person has control and access to it, ME.
Recently I needed to develop a piece of unusual ASP software, kind of like a spider, with an auto repeat loop to make it do what it needs to do.
And that particular error started appearing, so I traced back to what was causing it.
It's a kind of fault in the ASP engines session controls, a bit like a non truncated file.
It only occurs when repeated actions take place using the Server.CreateObject("ADODB.Connection") command a sufficient number of times without fully closing the object properly, at that point that the session buffer overruns and locks up.

Solution.
Well now this is a killer, because if you sharing the server running the ASP, it is not necessarily you that is causing the problem, because any other hosted site using the same application server, can produce the problem for every web site using the same application server.
Now being at that I have full control over the server the solution I applied was to change the settings on the host server disabling "enable session state". And the problem was instantly solved and has never returned.
Unfortunately you might can imagine this means that effectively the server when in this state has no session ID at all.
But it is the only solution that actually properly works.

So in short what you have here is endemic fault with the Microsoft ASP engine.

  #20 (permalink)  
Old January 11th, 2005, 09:42 AM
Registered User
 
Join Date: Jan 2005
Location: , , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I also suffer from this particular error.

What does it mean if the server has no session ID state with this option been disabled?

Thanks.
Mike
 


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 04:39 PM.


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