Question:
Actually, I installed this LocalDB separately (without installing Express 2012, I just downloaded msi). Everything is working. Now I'm trying to load information there from xml using SQLXML 4.0 like this:
SQLXMLBULKLOADLib.SQLXMLBulkLoad4 objBL = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4();
objBL.ConnectionString = "Provider=sqloledb; server=(localdb)\v11.0; database=mynewdb; integrated security=SSPI";
objBL.ErrorLogFile = "error.xml";
objBL.KeepIdentity = false;
objBL.SchemaGen = true;
objBL.SGDropTables = true;
objBL.Execute("AS_NORMDOC.xsd", "AS_NORMDOC.xml");
I get this error on Obj.Execute :
COMExeption not processed
Error connecting to the data source.
In detail view, HResult and ErrorCode are -2147467259
Answer:
If everything is correct in the connection string, then I think that the loaded document should be looked at for errors. Here's an example on msdn: https://msdn.microsoft.com/ru-ru/library/ms171878%28v=sql.110%29.aspx