one procedure is there for validating ,dumping and to split the data into multiple tables using OPENROWSET('Microsoft.Ace.OLEDB.12.0').

here validating means checks for sheet names, columns in sheet or correct or not.

when this procedure invoked from .net application it gives error

now i tried from sql server management studio it works properly, but from application it gives error.