Solved

"Unable to initialize DAO/Jet db engine" error from CDaoDatabase() class

Posted on 2006-07-11
13
2,789 Views
Last Modified: 2012-08-14
Not sure if this is an ACCESS question or a programming question but I'll start here...

I have a MS Access database, db.mdb, that is accessed by a C++/MFC program using the CDaoDatabase class as such:

      CDaoDatabase *pDatabase = new CDaoDatabase();
      pDatabase->Open("C:\\<some_path_to_the_folder>\\db.mdb");

      CDaoRecordset rs(pDatabase);

It's worked fine for months, perhaps years.  But today it's started reporting a dialog that says:

"Unable to initialize DAO/Jet db engine"

when the line:

      pDatabase->Open("C:\\<some_path_to_the_folder>\\db.mdb");

is executed.  Not sure what's going on or what has changed but I'm baffled.  As far as I can tell, Access itself runs normally on this database.  So I suspect it's some issue with DAO but I'm not sure how to fix it.

This is running on XP SP2 and I tried to install the MDAC 2.8 SP1 but get an error that says:

"This setup does not support installing on this operating system"

Ok, I think that because XP SP2 INCLUDES MDAC 2.8 and will not install again.  I did try installing MDAC 2.7 but that didn't seem to make any difference.
0
Comment
Question by:jhance
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 4
13 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 17081879
is it only on one machine?
if so I think we can find the list of files you may need to unregister / re-register.

Steve
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17081883
DAO is part of the Jet engine not the MDAC since about MDAC 2.5
0
 
LVL 32

Author Comment

by:jhance
ID: 17081943
This is a one-off application.  So yes, it's only on one machine.


jimpen,

Ok, so DAO is a part of the Jet engine.  Any suggestions on how to fix this?
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 38

Expert Comment

by:Jim P.
ID: 17081960
0
 
LVL 39

Expert Comment

by:stevbe
ID: 17081974
right ... dao is part of the OS and not MDAC so it could have been installing XP SP2

this KB talks about 95 but I think the register part still applies
http://support.microsoft.com/kb/q177264/

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
0
 
LVL 32

Author Comment

by:jhance
ID: 17082004
jimpen,

When installing the KB you suggested I get:

KB829558 Setup Error

Setup has detected that the Service Pack version of this system
is never than the update you are applying.

There is no need to install this update.
0
 
LVL 32

Author Comment

by:jhance
ID: 17082022
stevbe,

I did:

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll

on my system and got the message that it was successfully registered.  Unfortunately, the problem remains.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17082041
Ok.  Then follow stevbe's suggestion for the regsvr32.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 17082064
Does C++ have its own DAO dll of some sort?
0
 
LVL 32

Author Comment

by:jhance
ID: 17082175
I don't know, if there is, it's not obvious.
0
 
LVL 39

Accepted Solution

by:
stevbe earned 500 total points
ID: 17082328
Sorry, that dao350.dll was for 95, please re-register dao360.dll (that is the latest and greatest)
0
 
LVL 39

Expert Comment

by:stevbe
ID: 17082333
should be in ...

C:\Program Files\Common Files\Microsoft Shared\DAO
0
 
LVL 32

Author Comment

by:jhance
ID: 17082504
That did it...  Thanks!@!
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question