Ole db provider microsoft jet oledb 4.0 reported an error

->>>> Click Here to Download <<<<<<<-

You receive an 'Unable to load odbcji Cause Click-to-Run installations of Office run in an isolated virtual environment on the local operating system.

Jet Oledb 4. Select Import or Link , and then click OK. We're running SQL Server For a login not defined in that list above, connection will be "made without using a security context".

Properties of Microsoft. After deployment, the report runs fine under SSRS when user logged into the server locally. The report also works when user logged into the server via Remote Desktop Connection. The provider did not give any information about the error. I think the issue may be caused by the login does have sufficient permission to open the Excel linked server.

I have been sitting hours and hours trying to solved this issue with absolutely no luck. I have the following query:. EXEC sqlScript1.

The provider did not give any information about the error. I have no idea what else to try anymore; can anybody perhaps assist me with this? Due to progress in other areas such as reading in four columns, I didn't need to do this, currently. If someone has Microsoft's "ear", they might try dividing this error message into more meaningful categories with more information, because it doesn't help much. As in my own post, for a slightly different SQL function, it "checks" so the syntax is correct.

However, I notice that you have an Excel file in the Office format. I would not really expect the old Jet provider to be able to read that format. What happens if you save the file as an. I would also recommend that you give more information about your setup. What version of SQL Server do you have?

Which OS do you have? However, linked servers won't work against Access. The working syntax for excel spreadsheet files is as follows: --using ad hoc distributed query, which can be converted to linked server using above sp. In this situation when we deploy the 4. Was this reply helpful? Yes No. Sorry this didn't help.

Thanks for your feedback. What is your solution? A database? What bitness? What language? You have answered my questions.