Transactional replication fails with "ODBCBCP/Driver version mismatch" error.

Last Post 04 Aug 2005 09:28 PM by eleos111. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Bennykoh
New Member
New Member

--
29 Apr 2004 11:00 PM
Hi,
I trying to create a transactional replication of Database 'Test' from Server A to B (both running SQL 2000). I got B to subscribe to A, which is publishing out table "Machine" from 'Test'.
However when I run the snapshot agent for this publication, I keep getting this error "The process could not bulk copy out of table '[dbo].[syncobj_0x3933334537424130]'." in the Snapshot Agent Error details. The error information has Category = "ODBC" , Source = "ODBC SQL Serrver Driver" and Full Message as "ODBC/Driver mismatch".

I had thought that the MDAC version were different on both servers so I checked. They both had MDAC 2.7SP1 Refresh version. Both servers are also running Windows 2000 SP4.

Please tell me what is wrong with my set-up. TIA for any answers!!
Bennykoh
New Member
New Member

--
02 May 2004 04:07 PM
SQL service Pack 3a
Bennykoh
New Member
New Member

--
03 May 2004 08:37 PM
yes, I have downloaded the component checker and found both servers are running
MDAC 2.7 SP1 and MDAC 2.7 SP1 Refresh.
Bennykoh
New Member
New Member

--
04 May 2004 07:02 PM
I have recreated the publisher for table "Machine" from 'Test' again. Ran it again and got the error "The process could not bulk copy out of table '[dbo].[syncobj_0x3745303033393644]'."

I could not find this table under "Tables" but found it under 'Test' database's "Views" as syncobj_0x3745303033393644]. Opened this view and saw the data I wanted to publish.
Bennykoh
New Member
New Member

--
06 May 2004 12:48 AM
On Server A that is both the distributor and subscriber, the MSSQLAGENT service is run under "LocalSystem" while the SQLAGENT service is run unde a domain account "LP\tkadm".
LP is our Domain.

On Server B (the subscriber), both the services are run under "LP\sysadmin" account.

Both "LP\tkadm" and "LP\sysadmin" are administrators in both A and B.

I tried to change B to run MSSQLAGENT as "LocalSystem" and SQLAGENT as "LP\tkadm". But the subcription still has the same error.
eleos111
New Member
New Member

--
03 Aug 2005 09:45 PM
I have the same problem. Publisher and Subscriber are on the same server.
As account to start sql services I use one with admin role: .\SqlAdmin .
Should I put the domain instead of the dot?

Thanks in advance...
eleos111
New Member
New Member

--
04 Aug 2005 09:28 PM
Thanks for your response.

Yes, it's in my domain.
The versions of the files mentioned above are:
sqlsrv32.dll: 85.1025
sqlsrv32.rll: 81.9001
odbcbcp.dll: 81.9031

Do you think that this is the problem?

akinja
New Member
New Member

--
05 Sep 2005 08:07 AM
I am also having this same problem. However, I looked at the previous fixes and my system is setup as recommened.
I have two servers A and B
Both are at SP4 running SQL Server Standard
Both are using the same service account which is a Domain account
Both are running SQL Server Agent with the same account that runs MSSQL Server Service

The big difference I see is that I am trying to setup replication of a very large table. The table consist of 82,500,000+ rows. The inital snapshot replication will run for about 30 mins and the snapshot agent history shows about 25,400,000 rows copied. It states "Table.dbo.syncojb_0x35333383232344546): 100000 row(s) copied. Total 25400000. The next statme says "Bulk copied snapshot data for article testtable1 (0 rows). Finally "The process could not bulk copy out of table [dbo].[syncobj_0x35333...]

I am considering just doing a Bulk Insert to server B just to get the two tables in sync.

Any idea where to look next.
Thanks
Akinja
abhijeetgirase
New Member
New Member

--
15 Apr 2007 07:33 PM
I was able to create snapshots easily.But for last few days I m not able to create it. Its saying The Process Could not bulk out of table '[dbo].[syncobj_0x37353939....] Please guide me there
You are not authorized to post a reply.

Acceptable Use Policy