SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\MyDB.MDB'; 'admin'; '',
Table1) AS Table1_1
Error:
SQL Execution Error.
Executed SQL statement: SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\MyDB.MDB'; 'admin'; '',
Table1) AS Table1_1
Error Source: .Net SqlClient Data Provider
Error Message: Cannot initialize the data source object of OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I have perfomed the following on the SQLExpress computer:
sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE
EXEC sp_configure 'xp_cmdshell',1
RECONFIGURE
Thanks.