Help and Support

PRB: ADODB Connection Error Operation Is Not Allowed When the Object Is Closed

View products that this article applies to.
Article ID:303673
Last Review:October 10, 2003
Revision:2.0
This article was previously published under Q303673
On This Page

SYMPTOMS

When you use Commerce Server, you may receive the following error message:
Sitename
The page cannot be displayed
We apologize for the inconvenience. Please try again later. If the problem persists, please contact our webmaster.
In the Microsoft Windows 2000 Application Event log, you see the following:
Event Type: Error
Event Source: Commerce Server 2000
Event Category: None
Event ID: 4097
Date: 7/25/2001
Time: 4:49:04 PM
User: N/A
Computer: SERVER1
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.

Back to the top

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 site's 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.

Back to the top

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: CommerceServer2000's 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.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

1.Open Commerce Server Manager, double-click Commerce Server Manager, and then double-click Microsoft SQL Servers.
2.Browse to the site's database (for example, Retail_Commerce).
3.Right-click the database, click All Tasks, and then click Take Offline.
4.Open Microsoft Internet Explorer and type the URL to the Commerce site.

Back to the top

APPLIES TO
•Microsoft Commerce Server 2002 Standard Edition
•Microsoft Commerce Server 2000 Service Pack 1

Back to the top

Keywords: 
kbprb KB303673

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.