Microsoft KB Archive/885545

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

Article ID: 885545

Article Last Modified on 9/22/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



SYMPTOMS
If your connection string for a Microsoft Commerce Server resource contains a colon (&quot;:&quot;) 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;



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



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:

Description: In CmdConnect::Parse, Missing catalog/catalog db name/catalog db server name, 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:

Description: Missing one or more of  = delimiters in the query.

Keywords: kbtshoot kbprb KB885545

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.