Re: Microsoft Jet database engine
From: Paul Baker [MVP, Windows - SDK] (paulb_at_online.rochester.rr.com)
Date: 07/23/04
- Next message: Ward: "array of UDT and a stream"
- Previous message: Sander Verhagen: "Preserving connection"
- In reply to: William \(Bill\) Vaughn: "Re: Microsoft Jet database engine"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Jul 2004 10:07:37 -0400
Yes, that's true, but not the whole story. I have some information that will
hopefully help, but I don't have all the facts because the documentation is
confusing.
Search for msjet40.dll in the DLL Help Database:
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp&SD=msdn
It suggests that Jet 4.0 is installed by Windows 98 Second Edition, Windows
Me, Windows 2000, Windows XP and Windows Server 2003. It is not installed by
Windows 95 or Windows NT 4.0.
Curiously, I don't see any versions of Windows or MDAC if I search for
msjetoledb40.dll in the DLL Help Database. Is this a mistake?
It seems to be installed by Windows 98, but I cannot find any evidence of
that on Microsoft's web site. Is this a mistake too?
Recent versions of MDAC do not include Jet, but recent versions of Windows
do:
INFO: MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers:
http://support.microsoft.com/default.aspx?scid=kb;en-us;271908
How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine:
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114#7
These articles imply that you don't need a pre-existing installation of Jet
to install Jet Service Pack 8. I don't know if this is true or not.
You cannot rely on it being in future versions of Windows. It will not be in
future versions of MDAC. There are plenty of Microsoft articles suggesting
that you should transition from Jet to Microsoft Database Engine (MSDE) aka
SQL Server Desktop Edition. I don't know what they're calling it these days.
The point is that Jet is considered obsolete, though is very commonly used.
There is no mention of Jet on the Data Access and Storage Developer Center:
http://msdn.microsoft.com/data/Default.aspx
Paul
"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:OoD0LCGcEHA.4064@TK2MSFTNGP09.phx.gbl...
> I don't think you can depend on JET being installed anywhere, but in some
> cases the MDAC stack is installed.
> Sometimes MDAC is installed with JET, but not lately. In any case, when
you
> use MDAC (ADO classic) and JET, you must assume that JET is not installed.
> Even if it is, it might be an older version that's incompatible with your
> application. Of course, when you install JET, there's no guarantee that
> existing applications will continue to work.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Shane" <Shane@discussions.microsoft.com> wrote in message
> news:C2FED39E-4ADD-4B5F-8976-ADF5A3BF89A3@microsoft.com...
> > Could anyone tell me on which operating systems the Microsoft jet
database
> engine is already installed?
> >
> > Regards
> >
> > Shane
>
>
- Next message: Ward: "array of UDT and a stream"
- Previous message: Sander Verhagen: "Preserving connection"
- In reply to: William \(Bill\) Vaughn: "Re: Microsoft Jet database engine"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
