Create Database Alias Using ODBC

Introduction

Many programs written in languages such as Java and c++, access databases. In order that the program may use the relationships set up in these databases, you have to associate each database with a driver of the appropriate type. This association is given an alias which is used to make the connection between the program and the database. You may use BDE or ODBC to create the alias. This document explains how to use ODBC.

The Process

Start ODBC from BDE found in the Borland c++ menu.
In the ODBC dialog select MS Access and click on the Add button.
When the second ODBC dialog appears select Microsoft Access driver and click on finish.
The ODBC setup dialog now appears and you can give your database alias the name used to access it from your program. Next you may fill in the optional description. Assign the actual database file by clicking on the Select button and choosing the file from the file dialog. Now you can click on OK and the alias is created .