Implementation Guide › Installing CA User Activity Reporting Module › Install the ODBC Client › Test the ODBC Client's Connection to the Database

Test the ODBC Client's Connection to the Database

The ODBC client is installed with a command line interactive SQL Query tool, ISQL. You can use this tool for testing your configuration settings and the connectivity between the ODBC client and the CA User Activity Reporting Module event log store.

To test the client connection to the database

1. Access a command prompt and navigate to the directory where you installed the ODBC client.
2. Start the ISQL utility, odbcisql.exe.
3. Enter the following command to test the client connection to the database:

   connect User*Password@DSN_name
   

   Use the data source name you created for this ODBC connection to the database for the DSN_name value. If your connection parameters are correct, you see a return message similar to following:

   SQL: connecting to database: DSN_name
   Elapsed time 37 ms.
   

Note:If your password contains the @ symbol, the iSQL utility fails to run properly, reading everything after the "@" as the DSN name. To avoid this problem, enter the password in quotes:

Connect User*"Password"@DSN_name