A colon in the SQL Account password causes a connection to a Commerce Server 2002 resource to fail (885545)
The information in this article applies to:
- Microsoft Commerce Server 2002
SYMPTOMSIf 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; RESOLUTIONTo resolve this problem, do not use a colon in a SQL Account
password for your Commerce Server SQL connection strings.MORE INFORMATIONWhen 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.
| Modification Type: | Major | Last Reviewed: | 9/22/2004 |
|---|
| Keywords: | kbprb kbtshoot KB885545 kbAudDeveloper |
|---|
|