There are some reports that this problem can be solved by upgrading to a
consistent MDAC versions on both machines. To determine the version
currently installed, there is a free downloadable tool here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

The following files must have matching file versions:

%SystemRoot%\system32\sqlsrv32.dll
%SystemRoot%\system32\sqlsrv32.rll
%SystemRoot%\system32\odbcbcp.dll

Where does this originate from? Possibly from a failed/partial installation
of MDAC qfe(s).

HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Using transactional replication with updatable subscribers on Sql 2000
Server SP3a. I have server A as the Distributor/Publisher and Server B is
the subscriber (both are QUAD cpu machines). I keep getting this error
message when starting the Snapshot agent to run the initial snaphot for the
publication. There is user data already at the publisher db but none at the
subscriber db if that makes sense.

"The process could not bulk copy out of table
'[dbo].[syncobj_0x3037303343463734]"

"ODBCBCP/Driver version mismatch

(Source: ODBC SQL Server Driver (ODBC); Error number: 0)"

Any ideas?