search cancel

How to test the CA Data Direct ODBC driver to check if its working?


Article ID: 52989


Updated On:


CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER 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



This document explains the methods to check if the CA Data Direct ODBC driver is working.


There are two ways to test the CA Data Direct ODBC driver

Method 1:

  1. Open the command prompt and navigate to $NX_ROOT/bin folder

  2. Run the command pdm_isql and hit enter. It will display the isql prompt. See Fig 1

    Fig 1

    <Please see attached file for image>

    Figure 1

  3. Type the command connect userid*[email protected]_SERVER_NAME Ex: connect ServiceDesk*[email protected]_TESTSERVER and hit enter

  4. It will display connecting to database casd_Server_Name. See Fig 2


    <Please see attached file for image>

    Figure 2

  5. If incorrect login information is provided or if there is any problem with the ODBC driver it displays an error message.

  6. Type Exit to disconnect

Method 2

  1. On the CA Business Intelligence Server, Go to Start->All Programs->Business Objects XI Release 2->Designer

  2. Login to Designer as Administrator

  3. On the Menu bar, go to Tools->Connections. See Fig 1

    Fig 1

    <Please see attached file for image>

    Figure 3

  4. Select CA ServiceDesk connection and click on Test. It should display the message "The server is responding" See Fig 2

    Fig 2

    <Please see attached file for image>

    Figure 4

  5. If it displays an error message, click on the Details button to find out more information about the error message. Click on Edit button to modify the settings.


Component: ARGIS


1558721069803000052989_sktwi1f5rjvs16vvy.gif get_app
1558721067936000052989_sktwi1f5rjvs16vvx.gif get_app
1558721066110000052989_sktwi1f5rjvs16vvw.gif get_app
1558721064033000052989_sktwi1f5rjvs16vvv.gif get_app