• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Avoid using the Borland Database Engine

How can I access a database without using the BDBE ?

Or can I pack it to the exe (etc) ?
0
Raptor062197
Asked:
Raptor062197
  • 2
  • 2
  • 2
  • +1
1 Solution
 
KECommented:
You can not access databases without the BDE - unless you want to spend the next few years into programming your own interface. I'll suggest that you read the distribution license, that tells which DLL is necessary to implement for the BDE to work.
You can then place these DLL's in your application directory, but i recommend that you use the installer provided with Delphi.

If your application is small in size, and doesn't relly heavliy on the database function, you could choose to implement your database functions in a standard binarry format. The read the files into memory and process your data in this way.

0
 
Raptor062197Author Commented:
Which files do I need to pack into the directory ? (Sorry, I am totally new to delphi)
0
 
KECommented:
Which version of Delphi are you using ?

If you look in your Delphi installation directory, there is a textfile named deploy.txt - this describes which DLL's are needed for each driver.

0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
mvz121697Commented:
Depending on the database you use, you can easily go without the BDE.
I use 'Apollo' for Delphi-applications which access Clipper and
Foxpro files (DBF/CDX).
I use 'Opus Direct Access' for accessing MS-Access files.

With both products (2 extra DLL's) , you can create a one-disk installation of your application (with BDE, you need at least 3)

Greetings,
MvZ

0
 
Raptor062197Author Commented:
mvz : Where can I get those drivers ?
0
 
BoRiSCommented:
You can connect using a ODBC Driver

1. First start the BDE Administrator from the Windows Start Menu
(it will be in the Delphi 3.0 folder.)

2. Now select Object|ODBC administrator from the main menu.
(this will bring up a list of currently installed drivers.)

3. Choose Add and then select the ODBC driver you would like to create
a data source for, then click on OK.

4. Next fill in the appropriate information for your driver.
(A minimal configuration will require the  Data Source Name field.
You will also need to fill in at least one other field that is a
location specifier for the data. This could be a path in the case of
Paradox or dBase tables or the Server field in the case of configuring
an Interbase ODBC driver.  Some non-exhaustive examples include; if

you are using Interbase you would select a path to a .GDB file, if
using Paradox or dBASE files you would specify the data directory
containing your tables or if you were using Oracle you would specify
the entry as it appears in your TNSNAMES.ORA file.  Once this is done
you have created a virtual driver and will be able to access your
database files through the datasource your created.)


0
 
mvz121697Commented:
www.luxent.com for Apollo
www.opus.ch for Opus

Greetings,
MvZ
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now