When I try to “preview” my changes I get a “could not establish a connection to the Database Server” message?

Synopsis
When opening a report, you receive an error message "could not establish connection to database"
Solution
This is a known issue in .rpt Inspector™ 1 pre-release and in .rpt Inspector™ 1 release -- as there was no ability to pass a specific ID and Password in ODBC to the database. .rpt Inspector™ 2 Professional Suite now allows a user ID and password to be passed to all supported database drivers.

Applies to

.rpt Inspector 1
.rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)
.rpt Inspector 2 Professional Suite (for CR9.x-CR10.x)