How to upgrade to DAO 3.6 using MFC?

[David A Hand]

I'm using MFC DAO 3.5 classes under VC++ 6.0 as a dynamic DLL. I want to
upgrade to DAO 3.6 using Jet 4.0. I've
found a couple of knowledge base articles that help (eg Q230727 and
Q230484), but a few things are unclear.

QUESTION 1:

Article Q230727 says to copy the SDK files from the servive pack 3 disk,
open DBDAO.DSW, and compile the
projects. It, of course, does not compile since MS has alot of absolute
paths. After fixing this, it creates the .DLL and
.LIB files. But if I'm using MFC as a DLL, do I need the .LIB files (I
already have the DLL's since Access 2002 is
installed)? When I insert the line:

AfxGetModuleState()->m_dwVersion = 0x0601;

MFC seems to load the proper DAO and JET DLL's even though no DAO 3.6
.lib files exist.

QUESTION 2:

The DAO headers in the SP disk are different than the DAO 3.5 headers.
Don't I need to copy these to the proprer
VC++ directory and recompile my project with them? I guess we'd have to
assume the non DAO part of MFC does not
depend on these headers? The MS articles I've found say nothing about
this.

Thanks

[Richard Muller]

Hi David,

I did this a year ago at a client site. As I recall, I downloaded and
installed the MDAC 3.6 update and then the Jet 4.0 update. Then I added the
version update in InitInstance, as you've apparently done.

Two more things:
Why don't you look into using SP5 rather than the older SP3?
Also, look into the PlatformSDK; that will bring your system up-to-date,
I think. (Read the docs about the order in which to do this, if you choose
to.

Regards,
Richard Muller

"David A Hand" <ha...@corestar-corp.com> wrote in message
news:3D215697...@corestar-corp.com...

[David A Hand]

Richard,

Thanks for the info. I'm still a bit confused though.

Richard Muller wrote:

> Hi David,
>
> I did this a year ago at a client site. As I recall, I downloaded and
> installed the MDAC 3.6 update and then the Jet 4.0 update. Then I added the
> version update in InitInstance, as you've apparently done.
>

Did you have to copy the .h files overtop the old DAO 3.5 files and recompile
the client application? I guess MFC dynamically binds to the .DLL, so I don't
need the .LIB files. The support dir contains alot of .h and other files that
don't seem related to DAO.

>
> Two more things:
> Why don't you look into using SP5 rather than the older SP3?

I'm actually using SP 5. I guess they wrote the article after SP3 was released.

> Also, look into the PlatformSDK; that will bring your system up-to-date,
> I think. (Read the docs about the order in which to do this, if you choose
> to.
>

I was not able to find anything for DAO. I guess MS is trying to force people to
ADO and .NET, but I don't plan to ever use .NET if I can avoid it.

Thanks,
Dave Hand