How do I get MATLAB 2017b to access MS SQL Server 2014 Databases?

I am having difficulty with Database Toolbox under MATLAB 2017b connecting with Microsoft SQL Server 2014. It appears the latter is set in 64-bit mode, but I continue to get from the app Database Explorer an error of ODBC Driver Error, SQL Server Native Client 11.0 SQL Server incorrect syntax whe n using the Native client, or the similar ODBC Driver 11 for SQL server error when using the ODBC driver. When doing line command, the return of conn.Message shows "No suitable driver found for jdbc:sqlserver://localhost. I have also tried this with an installation of JDBC drivers, with no difference in results. What is causing this issue? Instructions on line have been unhelpful in trying to diagnose the issue -- I need a step by step to try to diagnose and fix this.

Answer 1

[Prem Ankur]

Starting with MATLAB r2017a, Database Toolbox does not support JDBC-ODBC bridge as JAVA 8 does not support JDBC-ODBC bridge. There are several known issues with the ODBC-JDBC bridge implementation for ODBC drivers for 64-bit databases. Note that these are limitations of either the bridge or the driver and not of MATLAB/Database Toolbox. Therefore, It is recommend to use JDBC driver.

JDBC drivers are usually recommended on 64-bit machines for many reasons:

• JDBC is a platform independent solution.
• Not all vendors provide a 64-bit ODBC solution.
• The only initial step is adding to the classpath, unless using Windows authentication or other libraries.

I see that you have already tried installing JDBC driver. Have you also tried configuring it for Microsoft SQL Server? I recommend using the following step by step tutorial on installing and configuring JDBC driver for Microsoft SQL Server:

https://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html#bt42q7a-2

[Srinivasan Balan]

I tried to connect Microsoft SQL Server Management Studio to MATLAB; Couldn't succeed. When I followed the documentation instructions in mathworks and finally typed conn.message, it threw an error message as "'JDBC Driver Error: This driver is not configured for integrated authentication. ClientConnectionId:e825ed75-ac16-4586-9f56-93a2ce39459f". I followed the link shown above and gave that driver link in the JDBCDriverLocation. Any leads would help. Thanks.