Knowledge Base

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

Article ID: 152619

Article Last Modified on 10/16/2003

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