Microsoft Jet 4.0 OLD DB Provider

From: Jan Didden (Jan.Didden_at_(NOSPAM)Vereycken.BE)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 12:00:59 +0100

Hi,

We are trying to write a Delphi7 application that connects to an Access 2000
database.
We are using Delphi 7 Enterprise. Is ADO the best/fastest connection to
Access or are there better solutions ?

We have added an ADOConnection component and when we try to build a
Connection String we only get one Provider and that is "Microsoft OLE DB
Provider for SQL Server".

To connect to an Access 2000 databank we need the "Microsoft Jet 4.0 OLD DB
Provider".

We have installed MDAC 2.8
(http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d
-b037-185d0506396c&DisplayLang=en) and Jet 4 SP8
(http://support.microsoft.com/default.aspx?scid=kb;en-us;829558) but there
is still no "Microsoft Jet 4.0 OLD DB Provider" available.

Is there a tool to see what version of MDAC and JET is running ?
Anybody any clues on what we are doing wrong ?

Configuration
Windows XP SP1
Internet Explorer 6.0 SP1
Office 2000 SP3
Delphi 7 Enterprise

Thanks,

Jan

Relevant Pages

  • Re: I really hate .NET especially inside Delphi
    ... integrating its own code into those CRM, ERP, and suchlike packages may not ... "Enterprise" stuff always lags behind, but Delphi for .NET does not sell ... niches that can leverage a significant advantage with native code. ... Delphi isn't as isolated as it used to be either. ...
    (borland.public.delphi.non-technical)
  • Re: Delphi bugs and "moving" to Visual Studio debate
    ... /after/ any decision is made about extending the enterprise architecture. ... If decisions are made to abandon Delphi for its bugs, ... be aligned to a mainstream database technology. ... maybe Oracle would benefit most with a tool like Delphi! ...
    (borland.public.delphi.non-technical)
  • Re: RAD Studio Roadmap Updated
    ... Delphi is targeted for. ... So please explain how, in targeting departments of an enterprise, one is not targeting that enterprise. ... When Borland sales people go into an Enterprise to sell, they are trying to sell a large bundle of very expensive tools and consider IDEs and programming languages, at best, a necessary evil - and in fact did not actively try to sell those at all. ...
    (borland.public.delphi.non-technical)
  • Re: Delphi and the ALM vision?
    ... J2EE is all-over that like white on rice. ... I've seen enterprises running Java/J2EE on top of Windows as well. ... I don't see Delphi getting any traction in the Enterprise space until it ...
    (borland.public.delphi.non-technical)
  • Database Landscape for future Delphi work.
    ... I'm a died-in-the-wool Delphi fan, and have been programming in Delphi since ... So I switched my database to Jet 4.0 and to using ADO via Delphi's ... Good support for syncing w/ SQL Server. ...
    (borland.public.delphi.non-technical)