2
$\begingroup$

This question already has an answer here:

I am attempting to open a connection to SQL Server with Windows Authentication (SSPI) using OpenSQLConnection and JDBC.

dbConn = OpenSQLConnection[JDBC["Microsoft SQL Server(jTDS)", "servername/dbname"]]

However, I am getting the following error from this.

JDBC::error: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property. >>

How do I load the "Native SSPI" library so that this connection can be opened?

I need to use integrated security so cannot pass in the username/password combo. The jTDS feature matrix says that it supports Window Authentication and Mma appears to be using the latest version of the driver (1.3.1).

JDBCDrivers["Microsoft SQL Server(jTDS)"]
(*
JDBCDriver["Name" -> "Microsoft SQL Server(jTDS)", 
 "Driver" -> "net.sourceforge.jtds.jdbc.Driver", 
 "Protocol" -> "jdbc:jtds:sqlserver://", "Version" -> 3., 
 "Description" -> 
  "Microsoft SQL Server using jTDS - Version 1.3.1 - This supports \
   Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, and 2012.", 
 "Location" -> 
  "C:\\Program Files\\Wolfram \
   Research\\Mathematica\\10.0\\SystemFiles\\Links\\DatabaseLink\\\
   DatabaseResources\\sqlserverjtds.m"]
*)
$\endgroup$

marked as duplicate by Verbeia Oct 21 '15 at 2:52

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 2
    $\begingroup$ Have you been through this post in detail? mathematica.stackexchange.com/questions/10312/… $\endgroup$ – Gordon Coale Mar 26 '15 at 17:56
  • $\begingroup$ Thanks @GordonCoale . That did the trick. If it is just a matter of including an open source DLL in the install I wonder why Wolfram doesn't include it? $\endgroup$ – Edmund Mar 26 '15 at 23:18
  • $\begingroup$ I tend to agree. It took me 2 days to get the oracle jdbc driver working. $\endgroup$ – Gordon Coale Mar 27 '15 at 6:25
  • $\begingroup$ Admins, think you can merge this question with mathematica.stackexchange.com/questions/10312/… as it is solved by the process in that answer. $\endgroup$ – Edmund Mar 27 '15 at 12:28