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

ID: Q152619


The information in this article applies to:
  • 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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.