哪个数据库驱动程序可将DbVisualiser与Azure SQL一起使用？ [英] Which DB driver to use DbVisualiser with Azure SQL?

问题描述

我以前使用过Microsoft SQL Server Management Studio

试用1。管理员凭据错误

设置为

• 服务器名称 myDB.database.windows.net 作为数据库URL


• Azure SQL admin作为数据基本用户ID


• Azure SQL密码为数据库密码

通过该错误，使

 建立连接时发生错误： 
所选驱动程序无法处理指定的数据库URL。 
发生此错误的最常见原因是数据库URL 
包含语法错误，阻止驱动程序接受它。 
尝试使用错误的驱动程序连接到数据库
时，也会发生该错误。更正此问题，然后重试。 
  

可能相关

1. 连接到Ubuntu

   
   
   

   根据我的发现，第一个错误只是表示您连接字符串中有错误，建议您打开Azure管理门户并从那里复制相应的jdbc连接字符串。
   第二个错误表明您无法在数据库URL模式下ping服务器，切换到服务器信息模式，然后就可以了。

   
   

   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?

   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.
   

   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.

   解决方案

   I have no issue with DBVisualizer/jTDS driver though.

   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. The second error indicates you cannot ping server in database URL mode, switch to server info mode and you are good to go then.

   这篇关于哪个数据库驱动程序可将DbVisualiser与Azure SQL一起使用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！