You can also test your connection string using \Softrak\System\OCSTEST.EXE.
Copy and paste your connection string into the text box and Click "Test" to see whether the connection string is correctly formed. Also, make sure that you are specifying the correct UserId and Password for the data you are connecting to.
And make sure you are creating your File DSN's using the correct 32 or 64 bit ODBC administrator.
Edited by Andrew Bates (11/15/17 01:18 PM)
Edit Reason: Added caveat about 32/64 bits.
_________________________
Andrew Bates