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

Hi,

I believe your problem is not MDAC, but rather the jet driver
(odbcjt32.dll). I have found computers where this driver exists, but is
misconfigured. In ODBC Data Source Administrator (Settings, Performance and
Maintenance, Administrative Tools) on the "Drivers" tab you may be lacking
the required driver setting (even though odbcjt32.dll exists). I cannot
remember the fix we used. It may have been to reinstall the jet drivers. If
someone else doesn't reply, search on access jet driver odbcjt32.dll.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

"Preben Nyeng" <pny@xxxxxxxx> wrote in message
news:uIonCPcTGHA.4300@xxxxxxxxxxxxxxxxxxxxxxx
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: Requirements to Run ADO.NET Application
    ... you're saying the OleDbConnection string posted below may not work on all computers with the .NET framework installed? ... Take note that JET driver is installed with MDAC ... JET driver was pulled out of MDAC for a while and thus it isn't guaranteed to be available. ... Here is an example of a connection string to connect to an Access mdb ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access to MDBs
    ... And is there a way to do this but not have to install the ... H-U-G-E MDAC? ... I have been using the Jet driver under OleDbAdapter but I ... supporting Jet drivers in MDAC 2.6 and later. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Requirements to Run ADO.NET Application
    ... JET driver was pulled out of MDAC for a while and thus it isn't guaranteed to be available. ... "Kerry Moorman" wrote in message ... Here is an example of a connection string to connect to an Access mdb ...
    (microsoft.public.dotnet.framework.adonet)
  • Access to MDBs
    ... What is the best way to get data from an MDB ... H-U-G-E MDAC? ... I have been using the Jet driver under OleDbAdapter but I ... supporting Jet drivers in MDAC 2.6 and later. ...
    (microsoft.public.dotnet.languages.vb)