Register a database for use with ALERT 3.60 with the ODBC Data Source Administrator and Sybase SQL Anywhere 12.0
1. Open the ODBC Data Source Administrator on the computer.
- Choose Start>Control Panel.
- Double-click Administrative Tools.
- Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
2. Select the System DSN tab and click "Add" to set up a new data source.
Important! Make sure you do not select the User DSN tab. If you do, only the currently logged in user will be able to access the database.
3. On the Create New Data Source dialog box, select SQL Anywhere 12 and click Finish to open the ODBC Configuration for SQL Anywhere dialog window. You may have to scroll down the list to locate SQL Anywhere 12.
4. On the ODBC tab, enter a name for the data source in the Data Source Name box. Make the name unique and intuitive, as it is what you will need to select to open this database in ALERT.
Suggestion: Make this name the same as the folder name used which contain the actual database. This is often the name of the plant or company.
5. On the Login tab, do the following:
- From the Authentication drop-down list, ensure Database is selected.
- From the Action drop-down list, select "Start and connect to a database on this computer". Note: this is the common setup for most applications. If the database is on a server, then please refer to the ALERT Users Guide.
- In the Database file box, type the path to the database file or click Browse to navigate to it.
6. Click OK on the ODBC Configuration for SQL Anywhere dialog box.
7. Click OK on the ODBC Data Source Administrator dialog box.
The database now has a data source name and is registered with the ODBC Data Source Administrator on the computer. To verify this, launch ALERT and locate the data source name from the Data source drop-down list on the login dialog box.