Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Cannot initialize the data source...

0 views
Skip to first unread message

Will the Thrill

unread,
Feb 22, 2010, 3:08:14 PM2/22/10
to
Using SQL Express 2005, why do I get the error below from this query:

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.

0 new messages