How to manually Configure DataDirect ODBC Driver?
search cancel

How to manually Configure DataDirect ODBC Driver?


Article ID: 52280


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


Steps for configuring DataDirect ODBC Driver:

  1. Copy the oa_odbc_client folder from cd2\ca_tps.nt\CABO folder of the media.

  2. Click on Setup from the oa_odbc_client folder.

  3. Select the default location (recommended) or change the location to install and click Next.

  4. In the name enter casd_ServiceDesk_server_name (Servername should be upper case)

  5. In the TCP/IP address, enter the ip address of Service desk Server.

  6. The tcp port by default is 1706

    Note: Before proceeding to the next step, you have to map a drive to ServiceDesk folder on workstation.

    <Please see attached file for image>

    Figure 1

  7. In the Client key file, click on Browse and point to the oaclientkey.lic in the ServiceDesk/pdmconf folder or in the odbc_client folder you copied.

  8. Click on Next to finish the installation after the installation is complete,

    1. Go to Start->All Programs->Data Direct ODBC Driver->Interactive SQL,

    2. At the prompt enter connect priveledgedusername*[email protected]_ServiceDesk_Server_Name and hit enter,

    3. It will return back to the prompt. Try running a command select * from cnt and check if it works.

  9. Copy the oainfo.ini file from ServiceDesk/pdmconf/schema folder from ServiceDesk server to C:/CASD_ODBC/Schema folder.


Component: SDBOXI


1558713719240000052280_sktwi1f5rjvs16t5s.gif get_app