| Q/. Windows NT Errors and Solutions A/. ADODB.Recordset error '800a0e7d'
The application requested an operation on an object with a reference to a closed or invalid Connection object.
The message means that the database cannot be opened.
The reasons almost always have to do with NT configuration options. Normally the problem will be fixed by changing one or more of the options below.
Possible NT Configuration Options to check
The anonymous user IUSR must have read/write access to the database directory.
IUSR/**** (**** = server name ) write access. This needs to be set by the NT administrator.
The directory where you installed VP-ASP must be able to run scripts.
Password Synchronization needs to be turn off. This can only be done through the management console.
Caching needs to be turned off for Active Server Pages. ASP pages are created dynamically.
The Access 97 database support is not in your system and you may need Access 2000 database. Contact us and we can supply you with one.
If you have MDAC 2.5 installed you probably need and Access 2000 version of the shopping database. We can supply one or simply use Access 2000 to upgrade our supplied Access 97 database.
The directory where the database is located does not have write access. If you are on a web hosting company, most directories are read only to prevent hacking. The YVS500 database must be write able. You need to ask your web hosting company to create a separate directory and move the shopping.mdb database to that directory. Then update the YVS500 configuration file to point to that directory. Use our supplied diagnostic tool to test your configuration.
The directory where YVS500 is installed must be defined as a virtual directory with read and scripts permission
Session State is not enabled. See prb_sessionstate.htm
More Information
See Microsoft Knowledge Base for full description of permissions required for anonymous user IUSR
Permissions description for Windows NT
http://support.microsoft.com/support/kb/articles/Q187/5/06.ASP
http://support.microsoft.com/support/kb/articles/q175/6/71.asp
VP-ASP uses standard ADO connection opens.
This behavior occurs (open fails) when password synchronization is enabled for the IIS 4.0 application. In situations where Access is linked to Access tables across the network, this is caused by a combination of password synchronization being enabled and a bug in the Odbcjt32.dll version 3.51.1029.
http://support.microsoft.com/support/kb/articles/Q189/4/08.ASP
Disable password synchronization for the Internet Information Server 4.0
application. Use the following steps to disable password synchronization:
Open the MMC.
Edit the Properties page of the application.
Under the Directory Security tab, Edit "Anonymous Access and Authentication Control."
Edit the "Account used for Anonymous Access:"
Clear the "Enable Automatic Password Synchronization" check box.
In situations where Access is linked to Access tables across the network, disable password synchronization, see the following article in the Microsoft Knowledge Base:
Q180815 BUG: IIS 4 Fails When Using a UNC to Microsoft Access
More Microsoft Knowledge Base
Even Microsoft cannot be totally specific on how to configure NT. This article lists many configuration problems and points to numerous other articles.
http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP?LN=EN-US&SD=gn&FR=0
printable version Back to Main Page | 
