Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 885545 - Last Review: September 22, 2004 - Revision: 1.2
A colon in the SQL Account password causes a connection to a Commerce Server 2002 resource to fail
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;
To resolve this problem, do not use a colon in a SQL Account
password for your Commerce Server SQL connection strings.
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.
APPLIES TO
- Microsoft Commerce Server 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate