An ODBC User DSN defines a connection to a data source. An ODBC User DSN:
The setup instructions depend on whether you are accessing data from a Windows or Linux computer:
To set up an ODBC user DSN on Windows to Fernhill SCADA follow these steps:
The ODBC Data Source Administrator opens:
The Create New Data Source dialog opens:
Note: The list of drivers on your computer may be different to the list shown above.
The Fernhill SCADA DSN Configuration dialog opens:
Field | Data |
---|---|
Name | My Fernhill SCADA |
Description | Connection to local server |
Server | localhost |
The new connection to Fernhill SCADA will appear in the ODBC Data Source Administrator:
Note: If you are running Windows 7, or Windows Server 2008, the Platform column is not shown.
There are two different ways to configure an ODBC User DSN for UnixODBC on Linux:
These instructions assume you have registered the Fernhill SCADA ODBC Driver with UnixODBC. If you have not registered the Fernhill SCADA ODBC Driver with UnixODBC, do so now. The instructions depend on the Linux distribution you are using:
Follow these steps to use the UnixODBC GUI tool ODBCManageDataSourcesQ4 to configure an ODBC User DSN for Fernhill SCADA:
ODBCManageDataSourcesQ4
Note: If you see a Command not found error, install the unixodbc-bin package. The UnixODBC ODBC Administrator is part of this package.
The UnixODBC ODBC Administrator window opens:
The Create New Data Source dialog opens:
Note: The list of drivers on your computer may be different to the list shown above.
Note: Try to avoid double-clicking the Fernhill SCADA entry. A double click will open a dialog to configure the Driver properties.
The Data Source Properties (new) dialog opens:
See Supported ODBC Keywords for information on how these values change the ODBC driver behavior.
Field | Data |
---|---|
Name | FHS |
Description | Connection to Fernhill SCADA |
Server | localhost |
In the Server field you can enter any of the following to connect to another computer:
The configured DSN is now shown in the ODBC Administrator dialog:
Follow these steps to use the UnixODBC command line tool odbcinst to configure an ODBC User DSN for Fernhill SCADA:
[FHS] Description=Connection to Fernhill SCADA Driver=Fernhill SCADA Server=localhost
In the Server entry you can use any of the following to connect to another computer:
See Supported ODBC Keywords for a detailed description of the keywords supported by the ODBC Driver.
odbcinst -i -s -h -f unixodbc-fhs
Diagnosing Connection Problems
To learn how to solve problems connecting to a Fernhill SCADA Server.
For instructions on setting up an ODBC System DSN.
Setting up an ODBC Data Source Name (DSN)
For an overview of the different types of ODBC Data Source Name.
For the meaning of terms used in Fernhill SCADA.