10.4. Setting up the DSN (Data Source Name)
Prev Chapter 10. Write to a Database Next

10.4. Setting up the DSN (Data Source Name)

A DSN is a Data Source Name. Windows uses this name to identify the database you want to connect to. This tab lets you select an existing DSN, or create a new one if necessary.

Procedure 10.5. Open the ODBC Data Logging window

  1. In the DataHub Properties window, select Data Logging.

  2. In the Configure Database (ODBC) Data Logging section click the Configure button.

    [Note]

    The Data Logging Configuration interface is explained in detail in Section 10.3, “Configuring the Queue, Store and Forward”.

  3. Configure your DSN as explained below.

Procedure 10.6. Selecting a DSN

  1. To select a DSN, choose one from the drop-down box, and then enter the user name and password, if applicable.

    [Note]

    If your DSN is using Windows Authentication, leave the User and Password fields blank.

  2. Click the Connect button. A "Connected to ..." message should appear in the message box. If you get an error message in the box, consult your system administrator.

Procedure 10.7. Creating or Configuring a DSN

[Note]

Windows has different configuration programs for 32-bit and 64-bit DSNs. You need to use the 64-bit DSN administrator with 64-bit DataHub program, or you need to use the 32-bit DSN administrator with 32-bit DataHub program. The application name, odbcad32.exe, is the same for both the 32-bit version and the 64-bit version of the DSN Configuration tool. The difference is which folder it is in:

  • The 32-bit version is in C:\Windows\SysWow64

  • The 64-bit version is in C:\Windows\System32

Despite the apparent mismatch of folder names, those are correct. The DataHub instance will automatically choose the correct version when you select the Open DSN Administrator button.

  1. To create or configure a DSN, click the Open DSN Administrator button. This opens the ODBC Data Source Administrator window.

  2. Select the User DSN or System DSN tab, depending on how you plan to access your database.

    A user DSN is only available to the current user account, while a system DSN is available to any user account on the computer.

  3. Now you can add a new database or configure an existing one.

    Procedure 10.8. Add a new database

    1. Click the Add button. The Create New Data Source window will open, displaying a list of data source drivers.

    2. Select the data source driver that corresponds to your ODBC database. A data source setup window will open. Each data source setup window is different, but you should be able to find the appropriate entry fields easily enough.

    3. Enter the data source name and select the database.

    4. Enter any other required or optional information such as login name, password, etc. What entries need to be made and where they are entered depends on the particular data source setup window you are using.

    5. Click OK to return to the ODBC Data Source Administrator window. You should be able to see the new database and driver listed. If you need to make any changes, you can configure an exiting database, as explained below.

    Procedure 10.9. Configure an existing database

    1. Select a data source name and click the Configure... button. This takes you to the data source setup window (explained above) where you can make changes to the configuration.

    2. Make your changes and click OK to return to the ODBC Data Source Administrator window. Any time you need to make a change, you can go to this window.

  4. When you are satisfied everything is correct, click the OK button to exit the ODBC Data Source Administrator.

Once you have created a DSN, you can select it as explained above.

Prev Up Next
10.3. Configuring the Queue, Store and Forward Home 10.5. Configuring a Database Table