Tutorial > Connectivity > ODBC

Connecting to Access tables in 16-bit AT-Sigma SPC

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. (Note that under Windows 95/NT Sigma can read MS Access directly without setting up ODBC. More info here.)

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, set-up a datasource for your database. Be sure to specify a path to your mdb file. For the purposes of this explanation we'll say that the datasource name is MYDSN.
  1. Load the BDE Configuration utility.

  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 MYDSN 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.
  15. To edit an existing SPC file skip to step 23. Continue with the next step to create a new SPC file.
  16. Press the New button at the top left of Sigma’s tool bar. You will see the "Setup SPC" dialog box.

  17. Fill in all fields as needed up to the Alias edit field.
  18. Enter MYDSN in the Alias edit field.
  19. Enter your table name in the Table Name edit field.
  20. Press the Add button to add fields as necessary. Enter a user name and password for your Access 2.0 database if necessary. See the user’s guide or help file for details.
  21. Press the OK button. Now open this new Sigma SPC file.

    Editing an existing SPC file:
  22. In AT Sigma SPC, use Setup|SPC Edit from the pull down menus. Select your SPC file from the Open dialog box. Press OK. You will see the "Setup SPC" dialog box.
  23. Enter MYSDN in the Alias edit field.
  24. Enter your table name in the Table Name field.
  25. Add "Fields to Analyze" as needed. Enter a user name and password for your Access 2.0 database if necessary. See the user’s guide or help file for details.

Press the OK button. Now open this new Sigma SPC file.

Top < Prev