Microsoft KB Archive/152619

= BUG: SqlRpcParam% Failed with "YYYY/MM/DD HH:MM" Parameter =

Article ID: 152619

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q152619





SYMPTOMS
When you attempt to specify a string of a datetime as a parameter in an remote stored procedure (RPC) execution, error message 10039 appears:

Attempt to convert stopped by syntax error in source field.



CAUSE
The function SqlRpcParam rejects attempts to specify a datetime parameter if the datetime string used as the remote stored procedure parameter is in "YYYY/MM/DD HH:MM" format.



WORKAROUND
There are two possible workarounds for this problem.


 * Instead of using SQLDATETIME, use SQLCHAR as the datatype of the datetime string parameter.

-or-
 * Use the date string in different format.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5 and 6.0. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug KB152619

-

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

© Microsoft Corporation. All rights reserved.