KB186315 - BUG: Custom Stored Procedures Fail: Fractional Truncation Error

Article ID: 186315

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q186315

SYMPTOMS

Replication Custom Stored procedures may fail if you are using the Sqlsrv32.dll ODBC driver version 3.50.0305. The distribution will fail with the following error:

Error : 14151, Severity: 20, State: 1
Replication-Distribution: Task 'TaskName' failed.
01004[Microsoft][ODBC SQL Server Driver]Fractional truncation
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure <procname>
expects parameter <paramname> which was not supplied.

CAUSE

Escape sequences passed as parameters to a stored procedure are parsed incorrectly by the Sqlsrv32.dll ODBC driver version 3.50.0305.

For more information about Sqlsrv32.dll, please see the following article in the Microsoft Knowledge Base:

184433 : BUG: Escape Seq in Params to Stored Procs Are Incorrectly Parsed[odbc]

WORKAROUND

To work around the problem, use an earlier version of the driver (for example, version 2.6x).

STATUS

Microsoft has confirmed this to be a problem in the SQL Server Sqlsrv32.dll ODBC driver version 3.50.0305. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug kbpending KB186315