FIX: SQL Server Replication Synchronization to DB2 Subscriber Fails with Numeric Data Type (281191)
The information in this article applies to:
This article was previously published under Q281191 BUG #: 58503 (SQLBUG_70) SYMPTOMS When performing synchronization against a DB2 subscriber,
if the table being replicated contains a numeric column, the distribution agent
may fail with the following error message: A SQL error
has occurred. Please consult the documentation for your specific DB2 version
for a description of the associated Native Error and SQL State. SQLSTATE:
42601, SQLCODE: -104. CAUSE This behavior is caused by the binding of binary data to
the OLE DB data type DBTYPE_NUMERIC or DBTYPE_DECIMAL.
STATUS Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbbug kbfix KB281191 |
|---|
|