Some solutions to ASP Error 0115

Some solutions to ASP Error ' 0115 '
The general view:
ASP Error 0115 means that one component in your ASP failed to invoke, and the ASP
It is not possible to get more error messages from this failure.

Error ' ASP 0115 '
Unexpected error
/scripts/<filename>
A trappable error occurred in A external object. The script cannot continue running.


ASP error ' 0115 ' is a nightmare for ASP developers, this error means
A component used by ASP has been crash off. The most fatal thing is that you are not able to get more detailed error messages.
So there are a lot of things that can lead to this error, which leads to a lot of different solutions.
Here are some of the more classic solutions:
(i) (For IIS 3/4):
The order in which the server-side programs are installed:
Sometimes when you install new software in the wrong order on the server, some versions of the new DLL are overwritten by the old version.
The exasperating thing is that you are not usually notified that these key dynamic connection libraries are overwritten. In these mistakes, you should especially be aware that when you
When you install any data components that involve VB5 (dll,ocx), ADO DLLs are not overwritten with older versions of the VB5 installer.
Instead, the VB5 installer installs the older version of the DLL into the Windows\System or Winnt\System32 directory, and registers it in these directories
These DLLs (they will replace your new version of the DLL in your registry for the default directory location in IIS),
To solve the problem caused by VB5 is to re-register your original DLL again.
(b) A recommended sequence for installing a server-side program:
Windows NT 4.0
NT 4.0 Option Pack (IIS 4, etc.)
NT 4.0 SP4
SQL Server 7.0
MDAC 2.0 SP2
IE 5.0
(iii) error caused by MDAC version:
Installing the latest MDAC version can help you solve a lot of confusing ASP 0115 errors. The latest version can be downloaded to Microsoft's Web site.
(iv) Security issues arising from anonymous accounts:
The permissions of the anonymous account determine the correctness of certain functions in the components that you need to access in your ASP.
A) If the user does not have the appropriate access rights, ADO DLL will be the wrong: ' 0115 ' error.
b Make sure that your anonymous account has access to the following directories: System32 directory, inetpub directory, directory where your RDBMS is installed, and the directory where the ADO DLL resides
(v) Errors that occur when submitting form
For this error please refer to the article ID in MSDN as Q173741
(vi) errors caused by poor code habits:
Sometimes ' 0115 ' is caused by your bad code (but maybe the same code will not make mistakes on different machines because of the different luck)
A When a page submits a form to itself, no value is assigned to the form's Name property
b When writing a DLL, the variant is not declared as a variant of the type
c) when calling a nonexistent stored procedure, or invoking the parameter of the stored procedure to pass an error.
(vi) For programmers who use IIS 3:
A) Error caused by session object:
Refer to the article KB article:q177036 in MSDN
b) ADO 2.0:
Error installing ADO 2.0 in IIS3, refer to the article in MSDN: KB article:q193310