Symptom
Error: "Unable to open source"
A bad filter causes this and will give a generic error of "bad source connection". It has nothing to do with the Data Definitions or any kind of oddly programmed ODBC connections.
Resolution
Identify the bad filter, and correct, or remove it. System database Filters need to be updated after an OnGuard version upgrade. In FormsDesigner:
- From the DataExchange menu, select Open.
- Select the DataExchange script you wish to open, and then click Open. *This only works with export scripts
- From the DataExchange menu, select Filters
- A "Filters" dialog box will be displayed with the following message: Enter SQL where clause: (to be applied to source database).
Confirm the filter is current with the existing database. Modify or delete if necessary. Click OK on the Filters dialog box- From the DataExchange menu, select Save.
- Run the DataExchange script again; it should now be updated to work with the new version of OnGuard.
Confirm the filter is current with the existing database. Modify or delete if necessary. Click OK on the Filters dialog boxApplies To
OnGuard (All versions)
Additional Information
Copyright © 2024 Carrier. All rights reserved.
