c# – Sql LocalDB 2012 и sqlxml 4.0

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

Scroll to Top
AllEscort