SQL 2008 R2 Merge Repl Error - Incompatible Version Error


we converting old replication application on sql 2000 / msde model sql 2008 r2 / sql express model.  have converted primary components of application , system setups (including creating subscription rmo objects, etc.)  mergepull replication situation.  we having 1 problem initiating synchronization through rmo controls.  client side application initiates replication on demand.  have setup code , connectivity both subscriber , publisher, merge fails due following error:

the version of sql server running @ subscriber incompatible publication. either upgrade subscriber 'unknown version of microsoft sql server' or change publication compatibility level of publication match version of sql server running @ subscriber.

error -2147467259

both publisher , sql express versions 10.50.1600. 

there issues how entries in publisher side sysmergesubscriptions table populated makepullsubscriptionwellknown function, modifying these entries still same error.  in looking @ agent.log, seems failure comes when sys.sp_msgetreplicainfo called publisher side.  it's @ point job fails.  don't know if stored procedure failing publication id or if it's failing find publisher entry subscription, or failing other value match.

does have better discription of above error code or come across problem before?

thanks help,

jason

i'm going have chalk 1 fault.  have lot of versions of sql installed , happened referenced libraries objects created mismatched version errors , not replication objects created publisher or subscriber.  once changed references in code, able error.


SQL Server  >  SQL Server Replication



Comments

Post a Comment

Popular posts from this blog

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

set datagrid current record to inserted record

i have master detail page datagrid , dataform. there text box users can enter client reference number. if th reference bumber not found, child window pops uo d ataform insert. want when new record inserted, , child window closed, current record in datagris should set inserted record.. how possible private sub addnewclient_closed(sender object, e eventargs) dim clients cwclientadminadd = sender dim dd domaindatasource = ria_clientselection if not clients.newtbcbi_client nothing dd.dataview.add(clients.newtbcbi_client) dd.submitchanges() else dd.cancelsubmit() end if end sub private sub ria_clientselection_submittedchanges(sender object, e system.windows.controls.submittedchangeseventargs) if e.haserror messagebox.show(e.[error].tostring(), "submit error", messageboxbutton.ok) e.markerrorashandled() else me.dgclientsearch.itemssourc...
Read more