XML 3 BulkLoad Error

[Panchal Hardik]

I have following error in window service same code is working in window Application "QueryInterface for interface SQLXMLBULKLOADLib.ISQLXMLBulkLoad failed." Dim objbl As SQLXMLBulkLoad3 objbl = New SQLXMLBulkLoad3 objbl.ConnectionString = "Provider=SQLOLEDB.1;Data Source=pcDB;Initial Catalog=webdb;User ID=sa;pwd=sa" objbl.ErrorLogFile = "c:\error.log" objbl.BulkLoad = True objbl.KeepIdentity = False objbl.CheckConstraints = False objbl.Transaction = False objbl.Execute("c:\Items.XSD", "C:\Items.xml") Thanks Hardik Panchal

[Dave Kreskowiak]

Don't cross post in multiple forums. It's considered very rude to "spam" the forums and makes it quite difficult for multiple people to collaborate on an answer.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007