Message Boards Message Boards

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

Posted 5 years ago

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 :-)

    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
POSTED BY: Michael Jensen
Posted 5 years ago

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/

POSTED BY: Michael Jensen
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract