Friday 26 February 2010

Delphi - Interbase Tutorial # 1 : Borland Database Engine

Connecting Interbase Database Using BDE (Borland Database Engine)

Manipulating and retrieving a database using some SQL codes is such a nightmare for me. But it does not mean that my previous Interbase Tutorials are useless. For database programmer, knowing SQL is a must. But the users do not need to know about SQL.

Now, I am going to share how to create user interface for manipulating, retrieving and maintaining a database. We can use any development tools to create the interface, but in this tutorial I use Delphi.

Before we start working with Delphi, we have to make an alias of the database. There many method of connecting database, but we’re going to use BDE (Borland Database Engine). After we start BDE Administrator from start menu, the main window will appear :

You can start creating a new connection by choosing Object – New

Choose the Interbase as database driver, then press OK :

You’ll get an alias name INTERBASE1 (see the picture below)

You can rename the alias name. In this case we use the alias name : ALIASMYDATA

Fill in the SERVER NAME the location of our database : C:\mydata\MYDATA.GDB
And USER NAME : NEW_USER
If our database located in a remote computer, we have to put the computer / server name. Use slash not back slash : server_name:/mydata/MYDATA.GDB
Then click apply as the picture above.
Now we have an alias for MYDATA.GBD. The user interface we’re going to develop using Delphi have to be connected to the alias : ALIASMYDATA

To test the connection choose File – Diagnostics. The Communication diagnostic Tool window will appear. Type the password, then click Test. If the connection work, you’ll get the results message that InterBase Communication Test Passed!

Go to Previous Tutorial or Next tutorial

10 comments:

  1. memang kamusnya tutorial nih keren

    ReplyDelete
  2. lengkap nih ada screenshotnya.. Thanks mas..

    ReplyDelete
  3. borlan ye, dulu cuma sempet ampe delphi aje skrg dah lupa semua hahaha, salam kenal balik ya :)

    ReplyDelete
  4. pengen sih belajar ini tp aq g punya banyak waktu sob

    coment sekalian folow

    ReplyDelete
  5. udah pernah nyobain dbExpert/Zeos om?sepertinya BDE udah gk trend skrng.cmiiw :D

    ReplyDelete
  6. @Fajar : I'd like to try DBExpert/Zeos as you suggest. I've been several years developing software using Interbase, Delphi and BDE. They've been fulfilling my needs.

    anyway thanks 4 the advise

    ReplyDelete
  7. waktu mau diagnostic, ada keterangan "comdg32.dll not found" .
    Any help? thanks

    ReplyDelete
  8. ralat..
    comdg32.exe

    ReplyDelete
  9. misi admin
    mau tanya cara nyetting bde ma oracle 9 gi mana ya?
    biar bisa konek

    ReplyDelete

These links are part of a pay per click advertising program called Infolinks. Infolinks is an In Text advertising service; they take my text and create links within it. If you hover your mouse over these double underlined links, you will see a small dialog box containing an advertisement related to the text. You can choose to move the mouse away and go on with your browsing, or to click on the box and visit the relevant ad. Click here to learn more about Infolinks Double Underline Link Ads.