N
N
nanosem2018-06-08 16:13:56
MySQL
nanosem, 2018-06-08 16:13:56

How to connect to azure using jdbc in netbeans?

Created SQL Server and database in portal.azure, added ip to firewall exceptions.
Tried to connect via MySQL (Connector/J driver) using connection string with azure:
jdbc:sqlserver://shintio.database.windows.net:1433;database=SHOP_DB;[email protected];password={your_password_here};encrypt =true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
password I specify the correct one.
Here is the error: Cannot establish a connection to jdbc:mysql://shintio.database.windows.com:1433/database=SHOP_DB using com.mysql.jdbc.Driver 
(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.)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
netrox, 2018-06-08
@nanosem

Mysql driver is not needed here.
https://docs.microsoft.com/en-us/sql/connect/jdbc/...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question