After upgrading to version 10, functions relying on a connection to a Microsoft SQL database no longer work. When I attempt to open a connection with something like:
Needs["DatabaseLink`"] conn = OpenSQLConnection[JDBC["Microsoft SQL Server(jTDS)", "server:port/DBName"], "Username" -> "user", "Password" -> "pass"]
I receive the error:
JDBC::error: net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
I have verified that this still returns a
SQLConnection with Mathematica 9. Other SQL connections (i.e. mysql) are still working for me in Mathematica 10. I still get the error if my machine is not connected to the network, so it can't be an interaction with the remote server. I'm running OS X 10.8.5.
How can I connect to the Microsoft SQL server with the new version of Mathematica?