Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A colon in the SQL Account password causes a connection to a Commerce Server 2002 resource to fail

A colon in the SQL Account password causes a connection to a Commerce Server 2002 resource to fail

View products that this article applies to.

Symptoms

If your connection string for a Microsoft Commerce Server resource contains a colon (":") in the SQL Account password, you may have a failure in the connection. For example, the following connection string contains a colon in the SQL Account password:
Provider=CSOLEDB;Data Source=Servername;Initial Catalog=Retail_commerce;User ID=test;Password=test:pwd;

↑ Back to the top

Resolution

To resolve this problem, do not use a colon in a SQL Account password for your Commerce Server SQL connection strings.

↑ Back to the top

More information

When the failure occurs, you receive two system event messages that do not indicate the real problem. The following two messages are written to the event log:

Event Type:�Error
Event Source:�Commerce Server 2002
Event Category:�None
Event ID:�32880
Date:��8/18/2004
Time:��9:25:24 AM
User:��N/A
Computer:�SERVER
Description: In CmdConnect::Parse(), Missing catalog/catalog db name/catalog db server name, Server: SERVER\sql, Database: RETAIL_Commerce, UserID: Test_DBUser


Event Type:�Error
Event Source:�Commerce Server 2002
Event Category:�None
Event ID:�32910
Date:��8/18/2004
Time:��11:42:49 AM
User:��N/A
Computer:�SERVER
Description: Missing one or more of� = delimiters in the query.

↑ Back to the top

Keywords: KB885545, kbtshoot, kbprb

↑ Back to the top

Article Info
Article ID : 885545
Revision : 3
Created on : 9/22/2004
Published on : 9/22/2004
Exists online : False
Views : 268