 |
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|

November 18th, 2003, 10:42 AM
|
Registered User
|
|
Join Date: Oct 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

November 18th, 2003, 10:58 AM
|
Registered User
|
|
Join Date: Nov 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
thanks i will try that if i will get the error again ... because once i restarted the iis and since then everything works fine ..
|

January 21st, 2004, 03:43 PM
|
Registered User
|
|
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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...
|

February 26th, 2004, 02:05 PM
|
Registered User
|
|
Join Date: Feb 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I am having the exact same errors dealing with a DB2 database. If anyone's solved this, please post.
|

February 27th, 2004, 06:36 AM
|
Registered User
|
|
Join Date: Feb 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|

June 6th, 2004, 08:03 AM
|
Registered User
|
|
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|

June 15th, 2004, 05:45 AM
|
Registered User
|
|
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

July 1st, 2004, 01:57 PM
|
Registered User
|
|
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|

July 7th, 2004, 09:25 PM
|
Registered User
|
|
Join Date: Jul 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|

January 11th, 2005, 09:42 AM
|
Registered User
|
|
Join Date: Jan 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
 |