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
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
Copyright © 2013 CA.
All rights reserved.
|
|