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...
http://www.replicationanswers.com/Default.asp
No comments:
Post a Comment