BUG: Custom Stored Procedures Fail: Fractional Truncation Error (186315)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB186315 |
|---|
|