>>  <<  Usr  Pri  JfC  LJ  Phr  Dic  Rel  Voc  !:  Help  User

Installing ODBC

ODBC must be installed on your system. An easy way to check for this is to look for the 32bit ODBC icon in Control Panel. ODBC is installed automatically with many Microsoft applications.

If you do not have ODBC installed, you may be able to obtain ODBC drivers from the Microsoft web site www.microsoft.com. Search for the ODBC FAQ (at the time of writing this is at www.microsoft.com/data/odbc/faq_odbc.htm).

To follow the examples in this chapter, you should install the dBase driver, even if you do not intend to use it later. When you install this driver, or any other driver, you will be prompted to enter the data source name. The data source indicates the DBMS driver and where the data files are stored. Note that it is not the name of a specific data file as may be imagined.

The examples here use the dBase driver, and files stored in J subdirectory examples\data, and the data source name used is jdata. To set this up, in Program Manager, select the ODBC icon in Control Panel. Use Add or Setup to create a panel as shown:

Note that you should at least have one data source name as shown above, but you can set up multiple data source names, using the same driver but typically with a different directory.

Although the data source name specifies a directory, this is in fact used by the dBase driver as the default directory. You can override this default either by specifying another directory when you connect to the dBase driver, or afterwards when you specify a file with its full pathname. However, note this capability is provided by extensions to ODBC in the dBase driver, which are not necessarily found in other ODBC drivers.

>>  <<  Usr  Pri  JfC  LJ  Phr  Dic  Rel  Voc  !:  Help  User