Tutorial > Connectivity > ODBC

Connecting to Access tables using ODBC

This tutorial will guide you through the process of setting up ODBC drivers. We will use an MS Access file as an example, but the steps are the same whichever ODBC driver you are using.

To get to Access data, you will be creating:

  1. ODBC Data Source
  2. BDE Driver
  3. BDE Alias

Once the BDE Alias is available you can use that name to get to the Access data.

The following steps will get you connected to an Access 2.0 database and table:

  1. Using the ODBC Administrator (Start > Settings > Control panel > ODBC 32), set-up a datasource for your database.
    1. Click on add, select Microsoft Access Driver, click OK.
    2. Enter MYDSN as the name.
    3. Click on database Select and locate the MS Access data base you wish to use. We have provided a sample data base, sig.mdb, located in samples\charts\access\ under the Sigma install directory.
    4. Click OK and then Close the Data Sources window.
  1. Load the BDE Configuration utility (Start > Programs > Sigwin32 > BDE Config 32).

  2. Select New ODBC Driver.
  3. Give the driver a name (call it ODBC_MYDSN).
  4. In the driver combo box select, "Microsoft Access Driver (*.mdb)"
  5. In the name combo box select MYDSN
  6. Press OK
  7. Go to the Alias page.

  8. Select New Alias.
  9. Enter MYDSNALIAS for name.
  10. For Alias Type, select ODBC_MYDSN.
  11. Press OK
  12. Select Save from the File menu.
  13. Select Exit from the File menu.
  14. Run AT Sigma SPC (Start > Programs > Sigwin32 > AT Sigma for gages).
  15. Press the New button at the top left of Sigma’s tool bar or select . You will see the "Setup SPC" dialog box.

  16. Fill in all fields as needed up to the Alias edit field.
  17. Enter MYDSNALIAS in the Alias edit field or click on List... and select MYDSNALIAS.
  18. Click on Find... by the Nable Name Input box and select RR.
  19. Press the Add button under fields to analyze to add fields.
  20. Select 0635 Diameter from the drop down menu and press OK. In the next window press OK to accept defaults.
  21. In the same was as described in the previous step, add fields 0317 diameter and Tongue Flatness.
  22. When the three fields are added, press the OK button.
  23. Save the file as myaccess in samples\access\.
  24. Now open this new Sigma SPC file by selecting . File > Open and select myaccess.spc
Top < Prev