Configuring ODBC access to the Sybase CCM database

Article:TECH108655  |  Created: 2003-01-08  |  Updated: 2005-01-01  |  Article URL http://www.symantec.com/docs/TECH108655
Article Type
Technical Solution

Issue



This document describes how to configure ODBC access to the CCM database.


Solution



All Database connections require the appropriate Driver installation before configuring any access parameters. A Sybase standard ODBC driver is delivered with the CCM installation but not registered in the Windows context.


Before you begin: You can also accomplish this by downloading and installing the Sybase ODBC Driver directly from Sybase. This requires user registration as a Sybase customer, free of charge.


To install the included ODBC driver
  1. Copy the following files from the ...\ccm\services\ccmdb\sybase folder on the CCM Server to the client you want to use for database access:
    dbodbc7.dll
    dblgen7.dll
    dbcon7.dll
  2. Create the registry key:

    HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0
  3. Add the following values under the new key:
    Value NameTypeValue
    DriverReg_SZ\dbodbc7.dll
    SetupReg_SZ\dbodbc7.dll
    Replace with the path to the files.
  4. Create the registry key:

    HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers
  5. Add the following values under the new key:
    Value NameTypeValue
    Adaptive Server Anywhere 7.0Reg_SZInstalled
  6. On the Windows Taskbar, click Start > Run.
  7. In the Run box, type odbcad32.exe and then click OK.
  8. On the System DSN tab, click Add.
  9. Double-click Adaptive Server Anywhere 7.0.
  10. On the ODBC tab, in the Name field, type CCM_ODBC
  11. On the Login tab, enter the following information:
    • Username: ccmguest
    • Password: password
    • Leave all other fields blank
  12. On the Database tab, in the Server Name box, type ccm**
    • Replace with the CCM server's network name.
    • Replace with the server's IP address.
    • The string must match the one defined in the ASADBNAME parameter of the ../ccm/config/dbin/ccm.bat file.
    • Leave all other fields blank
  13. On the Network tab, uncheck all except TCP/IP.
    If you are doing this on a CCM server, you can also check Shared Memory and Internal Pipes.
  14. On the ODBC tab, click Test Connection to verify that the connection works.





Technical Information
The Default TCP/IP Sybase configuration uses a Broadcast method to localize all available CCM Servers. If you access the Server from a different segment, the Broadcast will be probably blocked and the communication will fail. In this case, you should also add the CCM server name or IP Address on the Network tab.




Legacy ID



2003090806223060


Article URL http://www.symantec.com/docs/TECH108655


Terms of use for this information are found in Legal Notices