You need to install and setup up your ODBC driver
from the Windows Control Panel. To do this:
Open the Windows Control
Panel.
Click the ODBC icon to start the ODBC setup utility (if you do
not already have an ODBC icon in your control panel, you might need
to install the icon. See the documentation provided with your ODBC
driver).
Click Add to
set up a DataSource.
Note: If your ODBC driver is not
included in the list of Installed ODBC Drivers, return to the ODBC
setup utility and install your driver (select the Drivers... button).
From the Add
Data Source dialog box, select your ODBC driver. The Setup
dialog is displayed.
Enter the Data Source Name of the
driver that you used previously. For example, if you had used SQL
with a dBASEIII database, then your connection string would have
been "DRV=QEDBF". To avoid changing the connection strings
throughout your project, use a Data Source Name of QEDBF.
Run your CitectSCADA project.
Some Cicode SQL functions will not work if your
ODBC driver has limited functionality. This situation is not
frequently encountered, and in most cases affects only the ability
to use transactions with the SQLBeginTran(), SQLCommit(), and
SQLRollBack() functions. If you are using the Intersolv Q+E ODBC
drivers, it is unlikely you will experience any loss of
functionality.
You might need to change the data source in the
Control Panel each time you switch from using one ODBC-compatible
driver to another, for example from a dBASE file to an Access
database. Click the ODBC icon and select from the list of available
data sources. (Refer to the documentation supplied with your driver
for more information.)
Notes:
For maximum compatibility with
the Cicode SQL functions, the ODBC driver has to provide a minimum
of functions. For example, if your driver does not support the ODBC
function SQLTransact, you cannot use the Cicode functions
SQLBeginTran(), SQLCommit(), and SQLRollback().
Any functions you might have
created in early versions are backward-compatible. Q+E drivers are
now ODBC-compliant, so you need to upgrade your old Q+E database
driver to a Q+E ODBC database driver.