Used the ODBC data source administrator (via the control panel) to add a user DSN, then clicked on the "test connect" button and the following error occurred:
specified driver could not be loaded due to system error 1157
The common causes for this type of error is
1) Don't have the necessary ODBC drivers installed
2) The appropriate DBMS client software is not installed.
3) System Path is not set correctly.
Check the above causes and see if it helps resolve this problem. If the problem still exists then contact Micro Focus SupportLine. Check our website (http://www.microfocus.com) for SupportLine contact numbers (http://www.microfocus.com/AboutMicroFocus/contact/supportlinebycountry.asp)