SYMPTOM:
Consider the scenario in which a FreeForm SQL report is set up in an environment A. It is configured to use database instance A (also set as the project primary DB instance) which in turn uses DSN A.
Now assume that the FFSQL report is migrated to environment B using Object Manager. Environment B uses DB instance B as it's project primary, which in turn uses DSN B. After the migration, the FFSQL report is edited to ensure that DB Instance B is selected. The report is saved, closed, and then run, but the error message "Data source name not found and no default driver specified Connection String: DSN=A;UID=xxxx" appears.
Note that the error message states that the report is trying to use DSN A even though the FFSQL report DB Instance was changed to DB Instance B.
CAUSE:
This can be cause by performing a FFSQL report migration without updating the schema in the destination project afterward.
ACTION:
Update the schema in the destination project and re-edit the FFSQL report to ensure that it is using DB Instance B. Save and close the report and run again.
