How to use DAO 3.6 DLL

[Ankit]

Hi,

I have an application (written using VC++ 4.2). This connects to an
Access (95) database using DAO. Now due to some issues we decided to
move to the latest JET DLL (MSJET40.DLL). This DLL uses DAO360.DLL as
the COM wrapper.

Now to start with, I converted the DB to an Access 2000 DB. Then I just
renamed the msjet40.dll to msjt3032.dll and started the application
(this was just to test if things go smoothly with MSJET40). I found out
that even though msjet40 was getting loaded (albeit under the name of
msjt3032.dll), the DAO dll getting loaded was dao3032.dll. I basically
want to know how could I use DAO 3.6 alongwith MSJET40. Does it not get
loaded by default? If not, how do i get MSJET40 use DAO360.DLL?

I am not well acquainted with Jet and DAO programing, so please pardon
me if I am doing some crazy things; but kindly let me know as to how
could I proceed with this. Any kind of suggestions/advice/link to
reference material etc will be highly useful for me.

Thanks a lot in advance.
Ankit

[Tom van Stiphout]

On 19 Aug 2005 03:01:16 -0700, "Ankit" <an**********@gmail.com> wrote:

Sorry, but you are doing crazy things. Renaming a DLL filename is NOT
all that's needed to make Windows believe it's a different DLL. It is
also a technique that is highly non-portable. Don't do it.

-Tom.

Hi,

I have an application (written using VC++ 4.2). This connects to an
Access (95) database using DAO. Now due to some issues we decided to
move to the latest JET DLL (MSJET40.DLL). This DLL uses DAO360.DLL as
the COM wrapper.

Now to start with, I converted the DB to an Access 2000 DB. Then I just
renamed the msjet40.dll to msjt3032.dll and started the application
(this was just to test if things go smoothly with MSJET40). I found out
that even though msjet40 was getting loaded (albeit under the name of
msjt3032.dll), the DAO dll getting loaded was dao3032.dll. I basically
want to know how could I use DAO 3.6 alongwith MSJET40. Does it not get
loaded by default? If not, how do i get MSJET40 use DAO360.DLL?

I am not well acquainted with Jet and DAO programing, so please pardon
me if I am doing some crazy things; but kindly let me know as to how
could I proceed with this. Any kind of suggestions/advice/link to
reference material etc will be highly useful for me.

Thanks a lot in advance.
Ankit

[Ankit]

Hi Tom, I actually did realise that its not gonna work. So I did put in
calls to LoadLibrary, passing MSJET40.DLL as an argument to it. Now the
application does load MSJET40.DLL but still does not load DAO360.DLL
and hence gives errors. Looks like DAO360.DLL does not gets loaded with
MSJET40 by default. Any idea as to what is needed to get DAO360 loaded?

Thanks,
Ankit

[David W. Fenton]

"Ankit" <an**********@gmail.com> wrote in
news:11*********************@g14g2000cwa.googlegro ups.com:

Hi Tom, I actually did realise that its not gonna work. So I did
put in calls to LoadLibrary, passing MSJET40.DLL as an argument to
it. Now the application does load MSJET40.DLL but still does not
load DAO360.DLL and hence gives errors. Looks like DAO360.DLL does
not gets loaded with MSJET40 by default. Any idea as to what is
needed to get DAO360 loaded?

Since Active Directory uses Jet 4 as its data store, every Windows
PC from Win2K on includes Jet for in the standard Windows
installation. Now, that doesn't include DAO, of course -- that you
only get with Access, so far as I know.

To load DAO3.6 you have to reference the DAO3.6 DLL in your VB
project (however that is accomplished).

Sounds to me like you need a newer version of VB, which comes with
Jet/DAO included.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

"Larry Linson" <bo*****@localhost.not> wrote in
news:YTuNe.4346$xp.4029@trnddc02:

I think he can download the Microsoft Data Access Components
(MDAC) in whatever version is current, and it will include both
DAO360.DLL and Jet40.DLL. I don't know how you set References in
Visual C++, but I suspect you need references to both those DLLs.

I believe the MDAC dropped ADO support for Jet after v 2.5, but as
far as I know, it still has DAO for Jet. But, if you don't get
what you want with the current version, try to find MDAC 2.5.

Actually, didn't they just drop the Jet engine from the MDAC? That
would make since, given that it's already installed on all Windows
machines from Win2K on.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Baxter]

You can download the Jet Engine separately from the same page as the MDAC -
just scroll down farther.

--
---------------------------------------------------------------------
DataGet & PocketLog www.dataget.com
Data Collectors www.baxcode.com
--------------------------------------------------------------------

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142...

"Larry Linson" <bo*****@localhost.not> wrote in
news:YTuNe.4346$xp.4029@trnddc02:

I think he can download the Microsoft Data Access Components
(MDAC) in whatever version is current, and it will include both
DAO360.DLL and Jet40.DLL. I don't know how you set References in
Visual C++, but I suspect you need references to both those DLLs.

I believe the MDAC dropped ADO support for Jet after v 2.5, but as
far as I know, it still has DAO for Jet. But, if you don't get
what you want with the current version, try to find MDAC 2.5.

Actually, didn't they just drop the Jet engine from the MDAC? That
would make since, given that it's already installed on all Windows
machines from Win2K on.