"No such interface supported" error on Catalog.Create and Connection.Open

Hi,
I have a problem with an app using ADO and ADOX to access MDB files using
JET 4.0
The app runs well on anything from Windows 95 to XP, but on very few
machines the app will fail with the error mentioned in the subject.
I have seen it about 5 times on W2K with MDAC2.5, in each case an update to
the latest MDAC solved the problem.
But now I am stuck with an XP SP2 (MDAC2.8), because no newer MDAC is
available, and therefore an update is impossible.
There are 2 cases of the error:
1. When trying to open an existing DB (named OldDB). The ADO Connection
object is initialized with:
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Mode = adModeReadWrite
.Open("OldDB") fails.
2. When trying to create a new DB (named NewDB), using the ADOX Catalog
object:
.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=NewDB")

Any hints on how to solve the problem will be appreicated.
Thanks in advance,
Preben Nyeng


.

Relevant Pages

  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • Re: Run ADO/OLE DB from a CD-R
    ... using ADO/OLE Db from a CD. ... I need to get my VB6 app. ... also have had Visual Studio installed, however on all other machines, the ADO ... I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc) ...
    (microsoft.public.data.ado)
  • Conversion from BDE to ADO
    ... I am currently experimenting with converting a quite large app from BDE to ... capabillity e.g. if one user changes a record another has open and then the ... suggesting that ADO will slow my app down, ...
    (borland.public.delphi.database.ado)
  • install/deploy c# app
    ... My app includes CDO and ADO. ... name ADODB, or one of its dependencies, was not found. ... I also tried adding a setup project but it failed due to FxMdac Pugin ...
    (microsoft.public.dotnet.framework.setup)
  • install/deploy c# app
    ... My app includes CDO and ADO. ... name ADODB, or one of its dependencies, was not found. ... I also tried adding a setup project but it failed due to FxMdac Pugin ...
    (microsoft.public.dotnet.csharp.general)