Microsoft KB Archive/299314

= PRB: Merge Replication to Jet 4.0 Subscribers May Fail During Process of Applying the Initial Snapshot =

Article ID: 299314

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q299314



SYMPTOMS
Merge replication to Jet 4.0 subscribers may fail during the process of applying the initial snapshot, with the following errors reported in the output file for the merge agent:

Category:AGENT

Source: MS.Jet.4.0

Number: -1507

Message: Could not find field ''.

Repl Agent Status: 3

Disconnecting from OLE DB 'JetTest'

Percent Complete:0

Syntax error in CHECK constraint clause

Repl Agent Status:6

Percent Complete:0

Category:NULL

Source:Microsoft JET Database Engine

Number:-573443523

Message:Syntax error in Check constraint clause.

Repl Agent Status:3

These errors may be reported by the merge agent when it tries to apply schema changes, create indexes, or apply check constraints on the subscriber during the initial snapshot process.



CAUSE
This problem is usually caused by an incorrect version of the Microsoft Replication provider for Jet (Msrpjt40.dll) on the SQL Server 2000 publisher. The correct version for this DLL for SQL Server 2000 (RTM version 8.00.194) is 4.10.4320.0.



WORKAROUND
You can work around this problem in the following ways:
 * If there is a version mismatch for the above DLL, rename the wrong version of the DLL file, copy the correct version of the DLL from the SQL Server 2000 CD, and then reregister the new DLL by using the Regsvr32 utility.
 * Reinstalling MDAC 2.6 on the SQL Server 2000 publisher should also avoid this merge behavior by correcting any DLL mismatch.

WARNING: Do not install MDAC 2.6 on SQL Server 6.5 or SQL Server 7.0 clusters.

Keywords: kbprb KB299314

-

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

© Microsoft Corporation. All rights reserved.