Manoj Chaurasia Posted April 11, 2022 Share Posted April 11, 2022 Hi, on my local machine I've TIBCO Data Virtualization Studio and Server vers. 8.5 and a MySQL vers. 8.0.28 installation. I've created a sample MySQL database in order to try to connect it by TDV. I've tried to create a MySQL data source by specifying localhost as the Host and 3306 as the Port and then the necessary login and password, but I've obtained this error when testing the connection: Unable to connect to data source "/shared/examples/dv_test" at "localhost:3306@db_test" with the supplied connection information. [datasrc-3961050] Unable to connect to data source "/shared/examples/dv_test" at "jdbc:mysql://localhost:3306/db_test". Make sure the URL information, user name and password are correct. [datasrc-3961025] Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. [Log ID: 0ab94cf5-e4e5-4adf-ba89-e6f258e7a3ae] Now, any suggests to me in order to solve this issue, please Thanks Link to comment Share on other sites More sharing options...
Alain Martens Posted May 25, 2022 Share Posted May 25, 2022 Hi Pasquale, Are you able to successfully connect using DB client (like DBeaver) from the same machine where TDV is running With this you can exclude that the issue is within TDV (or not). Thanks, Alain Link to comment Share on other sites More sharing options...
Seung Jae Jeong Posted June 7, 2022 Share Posted June 7, 2022 Hi Pasquale, MySQL 8 use SSL as default. You need to disable a SSL mode as adding "useSSL=false" in JDBC URL. Thanks, Seungjae Jeong Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now