Company Events Academic Community Support Solutions Products & Services Contact NI MyNI

National Instruments Citadel 5 ODBC Setup Dialog Box

LabVIEW 2013 Datalogging and Supervisory Control Module Help

Edition Date: June 2013

Part Number: 371618J-01

»View Product Info
Download Help (Windows Only)

Requires: DSC Module

In the Windows Control Panel, navigate to Administrative Tools»Data Sources (ODBC). On the User DSN tab or the System DSN tab, click the Add button, select National Instruments Citadel 5 Database, and click the Finish button; or select an existing data source that uses the National Instruments Citadel 5 Database driver and click the Configure button to display this dialog box.

Use this dialog box to create or configure a Citadel ODBC data source that accesses historical data logged by the LabVIEW Datalogging and Supervisory Control (DSC) Module.

This dialog box includes the following components:

  • Data Source Name—Specifies the name that ODBC applications use to select the data source. Data Source Name must be different from any other ODBC data source name.
  • Description—Specifies a free-form text string you enter to describe the data source.
  • Database URL—Specifies the computer and database name for the data you intend to access, such as \\computer\database.
  • Test Connection—Tests the connection to the database. Click Test Connection to validate the connection to the Database URL you specify.
  • Time Zone—Specifies the time zone of the LocalTime column in the IntData table and the RawData table.
    • Use Operating System's Time Zone and Daylight Savings Time—Specifies to use the time zone settings of the Operating System and daylight savings time. By default, this checkbox contains a checkmark.
    • Custom Time Zone—Specifies to use a time zone other than the Operating System's time zone. This option is available only if the Use Operating System's Time Zone and Daylight Savings Time checkbox does not contain a checkmark.
    • Currently within Daylight Savings Time—Specifies that the current time is within daylight savings time. This option is available only if the Use Operating System's Time Zone and Daylight Savings Time checkbox does not contain a checkmark.
  • Custom alias names—Specifies to use user-defined alias names for trace and data set names. The Citadel ODBC driver automatically generates alias names for traces or data sets whose names are longer than the Maximum Column Name Length. However, National Instruments recommends you use descriptive alias names for trace and data set names.
    • Import list of comma separated <Alias, Full name> pairs from text file—Specifies whether to import a .csv file that contains a list of comma-separated alias names and original trace or data set names. By default, this checkbox does not contain a checkmark.
    • Alias File—Specifies the file path of the .csv file to import. This file defines a map of user-defined alias names and original trace or data set names.
  • Compatibility Options—Specifies compatibility settings for ODBC applications.
    • Maximum Column Name Length—Specifies the maximum number of characters allowed in each column of the Citadel data tables.
      Note  Some applications are not completely ODBC-compliant. If you plan to use Microsoft Query, Microsoft Access, or Visual Basic, make sure Maximum Column Name Length does not exceed 62 characters. These applications cannot handle longer names. Applications that are completely ODBC-compliant can handle names up to 126 characters long. The DSC Module generates aliases using internal trace IDs for all traces whose names exceed the Maximum Column Name Length. Shared variables that include network path information in their names might exceed the 62 and 126 character limitations of ODBC. Careful naming and organizing of objects can minimize the need for the DSC Module to generate aliases for lengthy shared variable names.
  • Performance Options—Specifies how the ODBC driver performs during a query.
    • Fetch Block Size—Specifies the number of rows that the ODBC client fetches in a single batch. When the value of Fetch Block Size is small, the ODBC client takes less time to update but takes more time to query data. When the value of Fetch Block Size is large, the ODBC client takes more time to update but takes less time to query.
    • Timeout—Specifies the time, in seconds, that the ODBC driver waits when retrieving data from the Citadel database. The default is 30 seconds. A Timeout value of 0 indicates no timeout, and the ODBC driver waits indefinitely until it receives data from the Citadel database.

 

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
Add Comments 1 2 3 4 5 submit