all groups > sql server replication > february 2005 >
You're in the

sql server replication

group:

snapshot agent error


snapshot agent error user
2/26/2005 6:17:18 PM
sql server replication:
Using transaction replication on Sql 2000 Server SP3 I have setup server A
as the Distributor and Publisher. Server B is the subscriber but keep
getting this error message on the snapshot agent for the publication.

"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?

snapshot agent error Paul Ibison
2/27/2005 2:21:57 AM
You could use this MDAC tool to determine if the versions
of MDAC on server A nad Server B are the same:
http://www.microsoft.com/downloads/details.aspx?
FamilyID=8f0a8df6-4a21-4b43-bf53-
14332ef092c9&displaylang=en
If not, then making them consistent should solve the
problem.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
AddThis Social Bookmark Button