XML problem
Here you are the VB Code
Dim objBulkLoad As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3
objBulkLoad.ConnectionString = "PROVIDER=SQLOLEDB;SERVER=(local);DATABASE=MyDB;INTEGRATED SECURITY=sspi"
objBulkLoad.KeepIdentity = False
objBulkLoad.CheckConstraints = False
objBulkLoad.IgnoreDuplicateKeys = False
objBulkLoad.ForceTableLock = False
objBulkLoad.Transaction = True
objBulkLoad.ErrorLogFile = "C:\errorlog.xml"
objBulkLoad.Execute "C:\import.xsd", "C:\import.xml"
Set objBulkLoad = Nothing
And here you are the VC++ Code
LPTSTR pstr = buf.GetBufferSetLength(nOrigLength);
_bstr_t stream((BSTR) buf.AllocSysString(),false);
HRESULT hr = CoInitialize(NULL);
ISQLXMLBulkLoad* pBulk = NULL;
hr = CoCreateInstance(CLSID_SQLXMLBulkLoad3,NULL,CLSCTX_INPROC_SERVER,IID_ISQLXMLBulkLoad,reinterpret_cast<void **>(&pBulk));
hr = pBulk->put_KeepIdentity(0);
hr = pBulk->put_CheckConstraints(0);
hr = pBulk->put_IgnoreDuplicateKeys(0);
hr = pBulk->put_ForceTableLock(0);
hr = pBulk->put_Transaction(1);
hr = pBulk->put_ErrorLogFile(BSTR("C:\\errorilog.xml"));
hr = pBulk->put_ConnectionString(BSTR("PROVIDER=SQLOLEDB;SERVER=local;DATABASE=MyDB;INTEGRATED SECURITY=sspi"));
hr = pBulk->Execute(L"C:\\import.xsd");
Thank you everybody

