Using ODBC to connect to CCM 7.0 Contact Center 7 1

[LKeys]

Two Day's of Searching the Internet for this but here is a summary of various threads.


Install Caché. (no longer using Sybase ASCE)

Install the following Caché ODBC driver:
ftp://ftp.intersystems.com/pub/cache/odbc/windows-ia32/ODBC-5.0.14.5702-win.zip

Under the System DSN tab
Create the ODBC connection using the Intersystems ODBC driver. You can name the connection whatever you like: ie. CCMS_CACHE_RENO

The Cache Namespace MUST be CCMS_STAT

Host {CCMS ip address}
Port 1972 {not 5000}

Password authentication

Test using the sysadmin username and password
(not a user with admin priv. )