How to use DAO 3.6 DLL

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

re: How to use DAO 3.6 DLL

On 19 Aug 2005 03:01:16 -0700, "Ankit" <ankit.saxena@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.

[color=blue]
>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[/color]

re: How to use DAO 3.6 DLL

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

re: How to use DAO 3.6 DLL

"Ankit" <ankit.saxena@gmail.com> wrote in
news:1124460525.843671.54000@g14g2000cwa.googlegro ups.com:
[color=blue]
> 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?[/color]

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

re: How to use DAO 3.6 DLL

"Larry Linson" <bouncer@localhost.not> wrote in
news:YTuNe.4346$xp.4029@trnddc02:
[color=blue]
> 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.[/color]

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

re: How to use DAO 3.6 DLL

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" <dXXXfenton@bway.net.invalid> wrote in message
news:Xns96B8CB44E37D4dfentonbwaynetinvali@216.196. 97.142...[color=blue]
> "Larry Linson" <bouncer@localhost.not> wrote in
> news:YTuNe.4346$xp.4029@trnddc02:
>[color=green]
> > 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.[/color]
>
> 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.
>[/color]