440 Chapter 17 Intelligent Queue
Creating ODBC connections
When you create a verified collected digits plan, you specify a data source against which Intelligent Queue
compares the collected digits. To connect to a data source, you must first create an ODBC connection.
Intelligent Queue officially supports three data source formats:
• SQL Server
• Microsoft Access
• Microsoft Excel

Creating an ODBC connection for SQL Server

To create an ODBC connection for SQL Server
1. Click Start=>Control Panel.
2. Double-click Administrative Tools.
3. Double-click Data Sources (ODBC).
The ODBC Data Source Administrator window opens.
4. Click the System DSN tab.
5. Click Add.
The Create New Data Source window opens.
6. Select SQL Server and click Finish.
The Create a New Data Source to SQL Server window opens.
7. Specify your ODBC data source information and click Next.
Your SQL Server can be local or remote.
8. Click With SQL Server authentication using a login ID and password entered by the user.
9. Verify the Login ID and Password are valid for the database you selected in the previous window.
10. Click Next.
11. Check Change the default database to and select a database from the list.
12. Click Next.
13. Click Finish.
14. If you want to test your ODBC connection, click Test Data Source. Otherwise, click OK to complete
the ODBC setup.
The ODBC connection is now available on the System DNS tab.
NOTE: It is highly recommended you test the ODBC connection before using it with Intelligent
Queue.

Creating an ODBC connection for Microsoft Access

To create an ODBC connection for Microsoft Access
1. Click Start=>Control Panel.
2. Double-click Administrative Tools.
3. Double-click Data Sources (ODBC).
The ODBC Data Source Administrator window opens.
4. Click the System DSN tab.
5. Click Add.
The Create New Data Source window opens.
6. Select Microsoft Access Driver.
7. Click Finish.
The ODBC Microsoft Access Setup window opens.
8. Specify a data source name.
9. Click Select.
10. Browse to the Access database you want to use and click OK.
11. Click OK to complete the ODBC setup.