到Sql Server 2012的Sql Developer连接器-错误“供应商代码207"； [英] Sql Developer connector to Sql Server 2012 - error "Vendor code 207"

问题描述

我正在尝试使用jTDS连接器jtds-1.3.1.jar从Sql Develper 4.0.3.16连接到Sql Server 2012.

I am trying to connect from Sql Develper 4.0.3.16 to Sql Server 2012, with jTDS connector jtds-1.3.1.jar.

操作系统:Ubuntu 14.04

OS: Ubuntu 14.04

Java:

~$ java -version
java version "1.7.0_72"
Java(TM) SE Runtime Environment (build 1.7.0_72-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.72-b04, mixed mode)

在创建连接"窗口中，当我测试连接成功时.

In the create connection window, when I test the connection it is successful.

当我打开连接时，我可以看到所有数据库.当我尝试打开应该具有打开权限的数据库时，出现以下错误窗口:

When I open the connection I can see all the databases. When I try to open a database that I am supposed to have a permission to open, I am getting the following error window:

有什么想法吗?

P.S.如果Microsoft有 JDBC驱动程序 sqljdbc4-4.0.jar(当我从Java代码连接到Sql Server 2012时对我有效)，那么为什么必须使用jTDS才能将Sql开发人员连接到Sql Server?当我尝试将其用作连接器时，似乎似乎Sql Developer不接受Microsoft jdbc驱动程序.

P.S. if Microsoft has a JDBC driver sqljdbc4-4.0.jar (which works for me when I connect from Java code to Sql Server 2012), then why do I have to use jTDS in order to connect Sql developer to Sql Server? It seems like the Microsoft jdbc driver is not accepted by Sql Developer when I try to used it as a connector.

在点击+

Before clicking on +

点击+

After clicking on +

推荐答案

As it's explained here, so far sql developer supports only up to sql server 2012. In my case I'm using 2014 version, which isn't supported.

更新 已经进行了一些更新，这些更新为较新的数据库提供了支持.签出它们，现在我可以使用SQL Developer连接到我的服务器了.

UPDATE There've been several updates, which provide support to newer databases. Check them out, now I'm able to connect to my servers using SQL Developer.

这篇关于到Sql Server 2012的Sql Developer连接器-错误“供应商代码207"；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！