I'm using MySQL and want to create an ODBC-Connection to my DB. I switched from localhost to a v-server. Locally the connection worked fine, but now there is a connection failure. Already checked if the port is correct, the mysql server is running and if skip-networking is "off".Thanks in advance.
Is the VM hosted in your data center or by a cloud provider?
How is the source endpoint type defined? As one of the MySQL endpoints, or as ODBC? MySQL, Amazon RDS for MySQL, Google Cloud SQL for MySQL, Microsoft Azure Database for MySQL, ODBC, ODBC with CDC?
FYI, ODBC endpoints are not recommended for endpoints that have a specific endpoint type already defined (there might be use cases for this that I am not aware of however). Also ODBC endpoints must be implemented with the assistance of our Professional Services team.
Try a MySQL client on the QR box to see if you can connect to your database. This might isolate if the problem is firewall (in our setup it is usually the case in a complex onprem 2 cloud), database setup, or an ODBC problem.
Hello thank you for the post to the QDI Forums. If you are setting up an ODBC connection you need to ensure the ODBC Datasource is defined to the ODBC Manager. If you are running Linux Replicate the ODBCINST.ini file would be the Datasource and ODBC.ini would be the driver location. If this is on Windows you would want to add the connection details via the ODBC 64 Bit manager. Hope this is helpful and another tip for Network issue you can use Windows telnet ip.address.com port <12345> if you get the blank screen the Firewall from Replicate Server appears to be none issue. Or this could be DNS type related issue. Let us know. And if needed you can open a Support case to have a TSE work with you.
Note: If this is Windows you may have to install Telnet from the Windows Add Program Features to add it.
