You can run iFIX and various tasks, such as the SQL task, as services under Windows. When you do this, you can log out of the operating system without shutting down iFIX ODBC. This provides a much higher level of security to your process, because operators can log in and log out of a node before and after their shift without affecting the process.
In order to run the SQL task (WSQLODC.EXE) as a service, you must use system data sources. If you attempt to use a user data source, you will get an error similar to the following:
Data source name not found and no default driver specified.
The procedure for configuring a system data source is similar to configuring other data sources. The only difference is that you must click the System DSN button in the ODBC Data Sources dialog box and add the data source you want. Refer to the System and User Data Sources section for more information on system data sources.
Refer to the Installing and Configuring Data Sources section for more specific information on configuring data sources for each database supported by iFIX ODBC.
