Symptoms

After specifying database credentials for your report, you are able to preview the report in the Report Commander Command Line Builder. However, when you execute the generated command from a command prompt, Report Commander fails with a database login error. The error message may include any of the following:

Error: Database connectivity test failed for table XXXX

Error: Failed to set database login parameters

Error: Failed to export report: Database logon failed

Cause

This problem may occur if the database password contains extended ASCII characters (such as the UK Pound (£) symbol) or Unicode characters. The encryption routine that Report Commander uses to encrypt the password for use on the command line fails to encode/decode these characters correctly.

Status

  • Report Commander 1
    This issue has been corrected and the fix will be included in the next maintenance update or software release. Customers affected by the problem may contact us to obtain the fix now.