Oracle Audio Technologies 8.1 - Manual (Page 23)

Installing CCA Server Components ■ Creating Database Connection to the Application
Server
Contact Center Anywhere Installation Guide Version 8.1 21
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = support-db)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORACLE)
)
)
Creating an ODBC Data Source for Ms SQL Server DB
To create an ODBC data source for SQL Server
1 From the Windows Start menu, navigate to Programs > Administrative Tools > Data Sources
(ODBC).
2 From the ODBC System Administrator System DSN tab, click Add.
3 Select SQL Server from the list and click Finish.
NOTE: If this option is not present, installing SQL Server Client Tools is required.
4 Provide the following information in the wizard dialog boxes, and click Next where appropriate.
Table 5. ODBC Data Source Settings for SQL Server
Field Description Comments
Name The name you want to use to refer
to the data source. The name should be similar to your
DB name, and it cannot include
spaces.
Description Text description of the data source. For example: Contact Center
Anywhere V8.1 Data Source Name
Server The SQL Server to which you want
to connect. For example: support-db
Login Select the option that specifies the
method SQL Server uses to
authenticate the login ID. SQL Server Authentication
Connect to SQL
Server to obtain
default settings Select the check box. Allows you to provide the up used
when creating the database.
- Login ID SQL server login ID For example: cc81
- Password SQL server Password For example: cc81