Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Connect to an Access MDB without using BDE?

Posted on 2009-04-02
3
Medium Priority
?
573 Views
Last Modified: 2013-11-23
Is it possible to connect to a Microsoft Access MDB file without using the Borland Database Engine?  If 'yes,' then how?
0
Comment
Question by:Monroe406
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 26

Expert Comment

by:Russell Libby
ID: 24056192
You have two other choices:

- Direct ODBC
- ADO

If the version of Delphi that you are using has the AdoExpress components then you are all set. Even if it does not, you can still import the type library information from msado15.dll which will give you the automation interface wrappers into ADO (and thus allow you to get the jet mdb). The other alterntive, and probably at a level you don't want to deal with, is by using direct ODBC SQLxxxx calls.

Your best bet is to figure out if you have the component wrappers for ADO in your version of Delphi. If you do, then check the help files for info regarding props/methods. If you don't, then import the ADO type library info and check the MSDN online for examples using ADO. Its fairly simple to use, and there are a number of resources on line for help.

Regards,
Russell
0
 

Author Comment

by:Monroe406
ID: 24056286
>> If the version of Delphi that you are using has the AdoExpress components then you are all set

I am looking at my Delphi 7 component bar, and I only see "ADO", not "AdoExpress".

When I look at my Delphi 2005 component list, I see a dbGo group with some ADO components.

I also have heard that using DAO is more efficient than ADO.  True?
0
 
LVL 26

Accepted Solution

by:
Russell Libby earned 500 total points
ID: 24056489

If you have an ADO component group, then you have"AdoExpress" installed which is what provides the components. (AdoExpress - Borland's terminology for the component wrappers they wrote which encapsulate the ADO COM interfaces by way of components).

As to DAO, that might have been true 10 years ago, but I would be hard put to believe it nowadays without evidence. DAO is antiquated, and moreover I'm not sure if its still even supported. Jet has a native OLEDB driver, which can be accessed via ADO (ADO is simplified wrapper over OLEDB). If you use the TAdoConnection and related components, you will find that you can access your mdb in the same fashion as you might have with the BDE, sans the BDE.

Russell
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question