Share
 
 

To Set Up a DBase Data Source Using ODBC

  1. Click the Windows Start button Windows System Control Panel.
  2. Double-click the Administrative Tools icon, and then double-click Data Sources (ODBC).

    You might need to click the Performance and Maintenance or System and Security category link based on you operating system.

  3. In the ODBC Data Source Administrator dialog box, do one of the following:
    • Click the User DSN tab to create a data source that is visible only to you and can be used only on the computer you create it in.
    • Click the System DSN tab to create a data source that is visible to all users who have access rights to the computer.
    • Click the File DSN tab to create a data source that can be shared with other users who have the same ODBC drivers installed on their systems.
  4. Click Add.
  5. Select the Microsoft dBase Driver, and then click Finish.
  6. Enter a name for your data source in Data Source Name, and select the appropriate version of dBase from the Version list.
  7. Make sure that Use Current Directory is cleared.
  8. Click Select Directory, and then locate and select the directory that contains the database tables you want to configure. Click OK.
  9. In the ODBC dBase Setup dialog box, click OK.
  10. In the ODBC Data Source Administrator dialog box, click OK.

Was this information helpful?