Saturday, February 25, 2012

Publication error ODBCBCP/Driver version mismatch

Hi.
I'm trying to setup a publication but I received an error:
The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.
I used the log to get more specific info and I got the following:
Microsoft SQL Server Snapshot Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: MyServer-MyMainDatabase-MyMainDatabase2MyTargetDatabase-4
Connecting to Distributor 'MyServer'
Connecting to Publisher 'MyServer.MyMainDatabase'
Server:
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31

max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[8/3/2005 4:43:30 PM]MyServer.MyMainDatabase: sp_MSgetversion
Initializing the publication 'MyMainDatabase2MyTargetDatabase'
*** [Publication:'MyMainDatabase2MyTargetDatabase'] Publication view generation time: 201 (ms) ***
*** [Publication:'MyMainDatabase2MyTargetDatabase'] Make generation time: 100 (ms) ***
Generating schema script for article '[ContactsCategories]'
Generating conflict schema script for article '[ContactsCategories]'
Generating referential integrity script for article '[ContactsCategories]'
Generating trigger script for article '[ContactsCategories]'
*** [Article:'ContactsCategories'] Time generating all schema scripts: 1762 (ms) ***
Generating schema script for article '[Contacts]'
Generating conflict schema script for article '[Contacts]'
Generating referential integrity script for article '[Contacts]'
Generating trigger script for article '[Contacts]'
*** [Article:'Contacts'] Time generating all schema scripts: 1292 (ms) ***
*** [System table:'MSmerge_contents'] .SCH script generation time: 10 (ms) ***

*** [System table:'MSmerge_tombstone'] .SCH script generation time: 20 (ms) ***

*** [System table:'MSmerge_genhistory'] .SCH script generation time: 21 (ms) ***

*** [System table:'sysmergesubsetfilters'] .SCH script generation time: 30 (ms) ***

[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[ContactsCategories] (TABLOCK HOLDLOCK) where 1=2
[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[Contacts] (TABLOCK HOLDLOCK) where 1=2
Bulk copying snapshot data for system table 'MSmerge_contents'
select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2
[8/3/2005 4:43:35 PM]MyServer.MyMainDatabase: select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2
SourceTypeId = 4
SourceName = MyServer
ErrorCode = 0
ErrorText = ODBCBCP/Driver version mismatch
The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.
Disconnecting from Publisher 'MyServer'


I have also found in another forum tha this is related with the files sqlsrv32.dll, sqlsrv32.rll and odbcbcp.dll. The versions of these drivers in my server are:
sqlsrv32.dll: 85.1025
sqlsrv32.rll: 81.9001
odbcbcp.dll: 81.9031
Is it really the problem in the versions of these files? Anyone knows how to update them and if there any risks by doing it?
Thanks in advance...

Try the link below to get started replication is one of the work in progress in SQL Server. Hope this helps.
http://www.replicationanswers.com/Default.asp

No comments:

Post a Comment