I am getting this message when running the snapshot agent:

Last Action: "The process could not bulk copy out of
table '[dbo].[syncobj_0x3230414139344244]'."

Error Descr: "ODBCBCP/Driver version mismatch"

Both servers are running SQL V7, sP3 and MDAC v2.6RTM

Any suggestions?

Regards, Josh

The error message basically means that there is a version mismatch among the
following ODBC dlls:

%SystemRoot%\system32\sqlsrv32.dll ("main" ODBC driver file for SQL Server)
%SystemRoot%\system32\odbcbcp.dll (ODBC BCP API implementation for SQL
Server)
%SystemRoot%\system32\sqlsrv32.rll (resource file for the SQL Server ODBC
driver)

You can check that this is indeed the case by checking the version
information of these files in explorer (right-click
file->properties->version tab). Off the top of my head, I don't know of a
good way to replace these files with the "good" version other than
installing a newer version of MDAC (which comes with its own set of risks)
as windows file protection may interfere. However, a google search (or MS
kb) may turn up something interesting.

-Raymond

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

When I installed my software and tried to back up using BCP it gave me
error ODBCBCP/Driver version mismatch.Actuall i have two version of
MDAC. currntly suppose old one is installed if u install new one it gave
me error .againg i installed old version but problem continues.I don't
know whether it is problem of registering dll or not.I am using MSDE of
SQL7 with sqldmo depending upon operating system.i.e i am registering
sqldmo and related dlls sapertly.


--