A great test tool to test connections from a machine/server to a data source is done by creating a UDL file on any machine(you can call it test.udl) and try a manual connection using the credentials in the Connection Setting and choose the correct provider. For example for a Oracle connection we use the Oracle OLEDB to connect to the server, if it is successful in the UDL, it should be successful in AppStudio and on requests form the AppServer. If not successful, then you will need to install the Oracle Provider, open the correct port, etc on the machine.
Have more questions? Submit a request