Provider cannot be found

I am getting a run-time 3706 "Provider cannot be found" error message when my
program is run on some computers running Windows XP SP2. The program uses the
following connection provider "Provider=Microsoft.Jet.OLEDB.4.0;" in my
connection string. I am trying to read values out of an Access 97 database. I
have tried to correct this by registering various dll's using regserver
though I am not sure of the proper file name, I have also upgraded MDAC
though I am told it may not have the right provider included in versions
after 2.6 and I have also tried to install the latest Jet service pack (SP8)
but it does not complete due to a message that the Service Pack version of
this system is newer than the update you are applying". I am looking for the
proper dll file name to use in the regsvr 32 command and information on
verifying that the provider dll is properly installed and available.
.

Relevant Pages

  • RE: Provider cannot be found
    ... > though I am not sure of the proper file name, ... > after 2.6 and I have also tried to install the latest Jet service pack ... > proper dll file name to use in the regsvr 32 command and information on ... > verifying that the provider dll is properly installed and available. ...
    (microsoft.public.data.oledb)
  • Re: sp3a forced install?
    ... > I had an issue where by the service pack did not install correctly but ... > I've tried to re-run it but it just hangs and does nothing, ... returns the proper version? ... Steve ...
    (microsoft.public.sqlserver.setup)