Solved

Connect to an Access MDB without using BDE?

Posted on 2009-04-02
3
546 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
  • 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 125 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now