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) ?
Raptor062197Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mvz121697Commented:
www.luxent.com for Apollo
www.opus.ch for Opus

Greetings,
MvZ
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.