ADO and JRO question
-
I have a need to replicate and synchronize an .mdb file in VC++ 6.0. I see that the JRO contains CreateReplica() and Synchronize() methods, these are precisely what I need to do. What I need to know is how to create the Replica object, I've seen reference to IReplica in the msjro.tlb file but I'm not sure what is the Replica equivalent of _ConnectionPtr. Once I know how to create the Replica object the rest should fall into place. Roger Cornell
-
I have a need to replicate and synchronize an .mdb file in VC++ 6.0. I see that the JRO contains CreateReplica() and Synchronize() methods, these are precisely what I need to do. What I need to know is how to create the Replica object, I've seen reference to IReplica in the msjro.tlb file but I'm not sure what is the Replica equivalent of _ConnectionPtr. Once I know how to create the Replica object the rest should fall into place. Roger Cornell
I've got a solution for my own question now, here it is. I've found out how to create a replica of an Access .mdb file through VC++. Here's the code. This code goes at the end of STDAFX.H #import "C:\\program files\\common files\\system\\ado\\msado21.tlb" \ no_namespace \ rename("EOF", "adoEOF") #import "C:\\program files\\common files\\system\\ado\\msjro.dll" MSJRO.DLL uses a namespace JRO. This code goes in a .CPP file CoInitialize(NULL); JRO::IReplicaPtr m_pReplica; HRESULT hr0; hr0 = m_pReplica.CreateInstance(__uuidof( JRO::Replica ) ); if(SUCCEEDED(hr0)) { CString m_connectString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\JDOCS\\Data\\JDOCS.mdb"; m_pReplica->PutActiveConnection(_bstr_t(m_connectString)); CString m_repName = "D:\\JDOCS\\Data\\JDOCSRep2.mdb"; CString m_repDesc = "JDOCS Database Replica"; m_pReplica->CreateReplica(_bstr_t(m_repName), _bstr_t(m_repDesc), JRO::jrRepTypeFull, JRO::jrRepVisibilityGlobal, -1, JRO::jrRepUpdFull); } CoUninitialize(); Roger Cornell