Sql Developer connector to Sql Server 2012 - error "Vendor code 207"

sql-server sql-server-2012 oracle-sqldeveloper jtds
rapt picture rapt · Jan 13, 2015 · Viewed 7.6k times · Source

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

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:

enter image description here

Any ideas?

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 +

enter image description here

After clicking on +

enter image description here

Answer

russellhoff picture russellhoff · Jul 23, 2015

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.

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.

Related questions

How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More
Auto increment primary key in SQL Server Management Studio 2012

How do I auto increment the primary key in a SQL Server database table, I've had a look through the forum but can't see how. I've looked the the properties but can't see an option, I have seen an answer …

Read More
Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More