Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Symptoms

One or more SQL Macro returns the following error:

Code Block
Error rendering macro 'sql-query' : Unable to connect to database using jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME> with user <USER>

Cause

Your SQL Macro is referencing a Data Source Profile that has one or more incorrect connection configurations. 

Resolution

Double check the connection information associated with this Data Source Profile (Hostname, Port, Database, Username, and Password). 

Include Page
SUPPORT:How to resolve the Unable to connect to database error
SUPPORT:How to resolve the Unable to connect to database error