Connect to SQL-server after updating to V12.0?

Questions
, ,
1

After I have updated to V12.0 I can’t connect to my SQL-Server. Initially I used to installation guide from https://mathematica.stackexchange.com/questions/129160/jdbc-to-odbc-bridge-gone-how-to-connect-to-sql-server-now-in-case-of-windows-au.
Is there anybody that could provide me with some hints?
Thanks :slight_smile:

    In[11]:= conn = 
     OpenSQLConnection[
      JDBC["Microsoft SQL Server (MS6 driver)", "srvsql03"], 
      "Properties" -> {"integratedSecurity" -> "true"}, 
      "Catalog" -> "AXProd"]

During evaluation of In[11]:= JDBC::error: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:b5f3d688-833f-4f6b-8a0e-2ac68003b74e".

Out[11]= $Failed
2

Response from support (Thanks, it works :-):

We do not bundle and ship the MS6 driver you are using with Mathematica (there are some licensing issues). Thus we do not support the same.

You should be able to use the jTDS driver which Mathematica incorporates to connect to your database:

JDBCDriver[“Name” → “Microsoft SQL Server(jTDS)”,
“Driver” → “net.sourceforge.jtds.jdbc.Driver”,
“Protocol” → “jdbc:jtds:sqlserver://”, “Version” → 3.1,
“Description” →
“Microsoft SQL Server using jTDS - Version 1.3.1 - This supports
Microsoft SQL Server 6.5, 7, 2000, 2005, 2008, and 2012.”,
“Location” →
“/Applications/Mathematica.app/Contents/SystemFiles/Links/
DatabaseLink/DatabaseResources/sqlserverjtds.m”]

Website: https://sourceforge.net/projects/jtds/files/jtds/