the same err. But i found something i think it permission issue and let me explain why.
I have ran the following sql code in a query
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=z:\test.xlsx', 'SELECT * FROM [Sheet3$]');
Login to my SSME with windows auth and it working it pull the data out of the excel.
did the same thing with my string user - same error message come up "Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
What permission my user need in order to be able to initialize the OLEDB? also i have notice that when i loged in under my user name in SSME i cannot see any of the Linked object, which i fix by give my user sysadmin rights. Thanks
everytime i use the network path without map drive i get the error if i map the network path im able to use it with windows auth account but not with regular SQL user. moretheless when im try to change the path on the web.config file it does not let me upload the file to anywhere else excpet under the virtual directory, if i was able to load this file to the SQL server i think it should solve all my problem.
