tebert0411
asked on
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
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.
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.