The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

tebert0411
tebert0411 used Ask the Experts™
on
When I run the following code in SQL Management Studio, I receive the error:

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

My operating system is Windows XP (32-bit), SP 2.  I've included the code, as I atttempted to run it.
SELECT *
	FROM OPENDATASOURCE(
	'Microsoft.Jet.OLEDB.4.0',
	'Data Source = \\server\directory\MSAccess.mdb;'
	)...TABLENAME

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try installing the JET engine on both the machine running the query and on the server as well (\\server\...)
http://support.microsoft.com/?kbid=829558 
 

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial