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

• Microsoft SQL Server versions 6.0, 6.5

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          : SSrvDB_Lib SSrvProg kbbug6.50 kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 28, 1999