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

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
• CA Service Desk Manager
• 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>

   
   
   
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>

   
   
   
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>

   
   
   
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>

   
   
   
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