Settings page

The "Test Connection / Preview" link provides a mechanism to test the connection to the database and see the data returned by the SQL command as set above

If there is a problem with the Connectioin string or SQL statement, the "Test connection / Preview" link will return the appropriate error.