December 12, 2008 at 8:03 am
I get this error on the Error Creation Initial Snapshot for Transaction Replication:
I had replicaiton for this database setup on 2000 with out any problems.
This replicaiton is from a SS2005 machine to a SS2000 machine.
Error messages:
Message: Data conversion failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
Message: Data conversion failed
Stack: (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
jcollins
June 16, 2010 at 3:49 am
I restored backups from sql 2000 to sql 2005 and when replicating two databases i get the same error:
essage: Data conversion failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
.....
If you have solved this problem, could you tell the real solution?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply