Action disabled: source
ce:community_edition_jet_driver

Community Edition JET Driver

Applies To: Windows XP

PROJECT in a box Commuity Edition stores infomation in a Microsoft Access database. The “JET” driver to access it is normally included as part of Windows. If you receive an error message such as the following, it may indicate that there is a problem with the JET drivers on your PC:

ERR=xxxx
MESSAGE=Provider cannot be found.
It may not be properly installed.
PROVIDER=Microsoft.Jet.OLEDB.4.0;
SOURCE=PiabDB.clsDB.GetConnection

Here are four suggested solutions for repairing JET on your PC.

Solution 1

You can install the latest service pack for the JET Database Engine 4.0 from: http://support.microsoft.com/kb/239114/

Solution 2

You may need to re-register the DLLs associated with the JET OLEDB provider with the following commands:

regsvr32 "C:\WINDOWS\system32\msjtes40.dll"
regsvr32 "C:\WINDOWS\system32\msjet40.dll"
regsvr32 "C:\WINDOWS\system32\msjetoledb40.dll"

Solution 3

You may need to repair your MDAC installion (Microsoft Data Access Components). Here is how to repair a copy of MDAC 2.8 on WinXP with SP2 installed

1. Locate the mdac.inf file in c:\windows\inf

2. Right click and select install

3. When prompted for a location, point to “c:/windows/servicepackfiles/i386”

4. Then when prompted for the XP CD, either load the CD or point to c:\i386

Solution 4

To re-register all the MDAC-related DLLS, copy and paste the following into a batch file and run it.

regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdadc.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaenum.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaer.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaipp.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaora.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaosp.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaps.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdasc.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdasql.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdatt.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdaurl.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdmeng.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msdmine.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msmdcb80.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msmdgd80.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msolap80.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msolui80.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\msxactps.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\oledb32.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\oledb32r.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\sqloledb.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\sqloledb.dll"
regsvr32 /s "c:\Program Files\Common Files\System\Ole DB\sqlxmlx.dll"
regsvr32 /s "C:\WINDOWS\system32\msjtes40.dll"
regsvr32 /s "C:\WINDOWS\system32\msjet40.dll"
regsvr32 /s "C:\WINDOWS\system32\msjetoledb40.dll"

ce/community_edition_jet_driver.txt · Last modified: 2017/06/22 13:17 (external edit)

Page Tools