on the client workstation adding IP and Port might be needed to the ODBC.
To add IP and Port please see the right syntax to add host=00.0.0.000;port=29152 for example make sure you use the correct syntax (word host and port) no spaces and ; instead of :