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

book

Article ID: 52989

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

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

Solution:

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

    Fig2

    <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.

Environment

Release:
Component: ARGIS

Attachments

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