Search code examples
sql-servermacosazureazure-sql-databasedbvisualizer

Which DB driver to use DbVisualiser with Azure SQL?

I have earlier used Microsoft SQL Server Management Studio here with Azure SQL here but I want to try DbVis (a platform independent alternative). I am trying DbVis in OSX. I could find JDBC driver for SQL Server here but not sure whether this required to use DbVis with Azure SQL in OSX.

Which driver do I need to select to connect to the Azure SQL in DbVis?

enter image description here

enter image description here

Trial 1. Error with admin credentials

The settings are

  • Server name myDB.database.windows.net as Database URL
  • Azure SQL admin as Database userid
  • Azure SQL password as Database Password

by which the error such that

An error occurred while establishing the connection:
The selected Driver cannot handle the specified Database URL.
The most common reason for this error is that the database URL
contains a syntax error preventing the driver from accepting it.
The error also occurs when trying to connect to a database
with the wrong driver. Correct this and try again.

enter image description here

Potentially related

  1. Connecting to Azure SQL in DB Vis under Ubuntu here (Q&A thread)

  2. Connect to Azure Management Data in Db Vis here (some article)

  3. Ticket in Db Vis asking for instructions to connect to Azure SQL dbs in Db Vis here.

Solution

  • I have no issue with DBVisualizer/jTDS driver though. enter image description hereenter image description here

    From what i see, the first error simply indicates you have error in your connection string, i'd suggest you open Azure Management Portal and copy the corresponding jdbc connection string from there. enter image description here The second error indicates you cannot ping server in database URL mode, switch to server info mode and you are good to go then.