When trying to set up multiple ODBC connections to numerous Informix databases, the following error appears:
"Test connection was NOT successful. [Informix][Informix ODBC Driver][Informix]Database not found or no system permission."
Is it possible to set up multiple ODBC connections to Informix databases?
This error will only appear if the Informix server names are identical, but on different servers.
Having multiple servers with the same server name will not work, it will just overwrite the older settings.
If there are multiple servers, ensure the Server Names are different.
