BUG: Custom Stored Procedures Fail: Fractional Truncation Error

ID: Q186315

The information in this article applies to:

Microsoft SQL Server version 6.5

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:

Q184433 : 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 : SSrvRep kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug