Re: Run time error 3706 Provider cannot be found. It may not be properly installed

Thanks Walter. This is actually an old application that I happened to need
to run for just a few days. So based on your finding, the only way is to
reinstall SP2? I have a few questions regarding reinstalling SP2:

(1). As you mentioned, Jet is no longer released with MDAC since Version
2.6, so how could reinstalling SP2 bring it back? As SP2 only installs
MDAC2.8?
(2). Will SP2 overwrite the updates I installed which were released after
SP2?
(3). Is there a place to download SP2 for individual computer? The only one
I found in the website is a SP2 download for mass network deployment
purpose.

Thanks,

Jesse

""Walter Wang [MSFT]"" <wawang@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:AJXvZf63HHA.2340@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

This error is similar to following KB which describes a situation that Jet
3.51 is not installed correctly:

#PRB: Jet 3.51 OLE DB Provider Is Not Installed With MDAC 2.1 or Later
http://support.microsoft.com/kb/197902


The solution is to reinstall Jet components. However, Jet is no longer
released with MDAC since version 2.6, that's why reinstall MDAC 2.8 on
your
side doesn't help:

#Microsoft Data Access Components (MDAC) Installation
http://msdn2.microsoft.com/en-us/library/ms810805.aspx
<quote>
In MDAC versions that are later than MDAC 2.6, Jet is not included with
the
MDAC components set; therefore, the Jet engine core components, the Jet
ODBC driver, and the Jet OLE DB provider are no longer included as a part
of MDAC.

The latest Jet components are available as a part of MDAC 2.5 SP2. If you
want to use MDAC 2.6 or later (including the latest Jet components), first
install MDAC 2.5 SP2, and then upgrade to the latest Jet components. You
can also obtain the latest Jet components for installation on existing
MDAC
2.6 and later installations as a stand-alone distributable file. For
information about obtaining this distributable file, see the Microsoft KB
article Q239114, How To: Obtain the Latest Service Pack for the Microsoft
Jet 4.0 Database Engine.

On Windows XP, the Jet components that are included with MDAC 2.5 SP2 are
preinstalled with the OS.
</quote>

As the KB 239114 mentioned:

#How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;q239114&id=q239114
<quote>
If you are running Windows XP SP2, you have a later version of Jet 4.0
than
the version that is included with Jet 4.0 SP8. We recommend that you
install the latest service pack for Windows XP. For more information about
how to obtain the latest service pack for Windows XP, click the following
article number to view the article in the Microsoft Knowledge Base:
322389 How to obtain the latest Windows XP service pack
If you cannot install Windows XP SP2, you can use
WindowsXP-KB829558-x86-ENU.exe to install Jet 4.0 Service Pack 8 on
computers that are running Windows XP. Click the following link to
download
and to install the correct version of Jet 4.0 Service Pack 8 on computers
that are based on the language version of Windows XP that is running on
the
computer
</quote>

Since you've already installed SP2, you cannot use the individual update.
You will have to reinstall SP2 to repair the Jet components.

Please let me know the result whether or not this helps.



Regards,
Walter Wang (wawang@xxxxxxxxxxxxxxxxxxxx, remove 'online.')
Microsoft Online Community Support

==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.



.

Relevant Pages

  • Re: Application deployment with Jet Database 4.0
    ... Basically you would install Jet in the same way as MDAC: ... exe that will launch the Jet setup before launching your msi. ...
    (microsoft.public.dotnet.framework.setup)
  • Re: Outlook.exe - entry point not found
    ... "I have tried to install the latest version of MDAC 2.8 but this can't be ... I'm using Window XP Pro SP2 and Office Standard 2003 SP2. ...
    (microsoft.public.outlook.installation)
  • Re: Will Jet 4.0 connection strings work on XP?
    ... Yes Jet has been removed from the latest 'n greatest MDAC_TYP packages. ... I think there might be some confusion about what the MDAC is. ... You can install newer MDAC packages as they become available. ...
    (microsoft.public.vb.database.ado)
  • Re: Windows XP SP2 and MDAC
    ... I'm having issues with Windows XP SP2 and MDAC 2.91. ... MS site states that MDAC 2.81 for Windows XP Pro can ONLY be found in SP2. ... and you can't install v2.81 stand-a-lone. ...
    (microsoft.public.windowsxp.general)
  • Re: Issues with Windows XP SP2 and MDAC 2.91
    ... I finially figure out that I had installed the wrong SP2. ... Also note that jet components are not part of MDAC ... | After installing SP2 and a SQL patch 4, I lost my Access ODBC drivers. ... | again, I have come to the conclusion, I would have to install SP2. ...
    (microsoft.public.windowsxp.general)