Microsoft KB Archive/186315

= BUG: Custom Stored Procedures Fail: Fractional Truncation Error =

Article ID: 186315

Article Last Modified on 10/3/2003

-

APPLIES TO


 * 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

expects parameter 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.