| Event Id | 4097 |
| Source | Commerce Server 2000 |
| Description | "Retail Error Type: ADODB.Connection Page: /retail/Default.asp File: /retail/include/global_siteconfig_lib.asp Line:280 80004005 Operation is not allowed when the object is closed. Note: Set Application(""MSCSEnv"") = DEVELOPMENT to turn on client error messages. Note: Please see error\500error.asp to further customize error messages. " |
| Event Information | "According to Microsoft: CAUSE : Commerce Server uses a Universal Data Link (UDL) data link connection over OLEDB provider to connect to the Microsoft SQL Server computer. These errors indicate that the connection to the sites database failed. Possible causes include the following: • The connection string is wrong. The password may have changed, the port may have changed, and so on. • The database is offline. • The SQL server is paused or stopped. • The SQL server is unreachable because of a network issue, such as a DNS issue, a changed name, and so on. RESOLUTION : To check the connection strings, follow these steps: 1. Open Commerce Server Manager, double-click Commerce Server Manager, and then double-click Commerce Sites. 2. Double-click the site that is not working, then double-click Site Resources. 3. Right-click Transactions and click Properties. 4. Click Modify to change the connection string information. NOTE: To change the SQL port number, you must add a comma and then the port number, as follows: SERVERNAME,Portnumber 5. Click Test Connection. Repeat this process for the Retail Data Warehouse ProductCatalog object, as well as the Campaign and Profile objects. After you correct the problem, you must restart the Commerce application by using IISReset. If you receive the following error message Error: CommerceServer2000s Administration database is not accessible, access to site is denied temporarily. there is a problem with the connection to the MSCS_Admin database. To verify the connection string, follow these steps: 1. Open Commerce Server Manager. 2. Right-click Commerce Server Manager and click Properties. 3. Click Modify to change the connection string information. NOTE: To change the SQL port number, you must add a comma and then the port number, as follows: SERVERNAME,Portnumber 4. Click Test Connection. " |
| Reference Links | ADODB Connection Error Operation Is Not Allowed When the Object Is Closed |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.