Database Connection problem migrating sql query to Matlab 2017

The following works fine in 2016b

conn_new = database('Azure Native Client', '', '')

curs = exec(conn_new, ...
    strcat('SELECT * FROM bkkn.v_matlab_model_input_v3  ',well_filter),'maxRows',20000)

However, it fails in 2017

Error using database.internal.ODBCStatementHandle/executeQueryV2 ODBC Driver Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.

    Database and Driver Information:

           DatabaseProductName: 'Microsoft SQL Server'
        DatabaseProductVersion: '12.00.2531'
                    DriverName: 'sqlncli11.dll'
                 DriverVersion: '11.00.2100'

Answer 1

[Harsh]

On the MATLAB side of things, there have been no changes to the Database toolbox and connection to Microsoft SQL Server between R2016b and R2017a as seen in the release notes here: Release notes

A few things worth checking are:

• Does the connection to the database succeed? If so, are you able to execute any other commands?
• Since you are using ODBC, confirm that the bitness of MATLAB, the drivers and database are all 64 bit since MATLAB no longer supports 32 bit drivers as shown here:

http://www.mathworks.com/help/database/ug/microsoft-sql-server-odbc-windows.html

• Double check the syntax of the query and the arguments being passed, especially "well_filter" .
• The error is a Database error and not a MATLAB error. Subsequently, make sure the most up to data drivers are being used. Please refer to Microsoft documentation for this. ODBC driver information can be obtained as follows: https://docs.microsoft.com/en-us/sql/odbc/admin/odbc-data-source-administrator
• If ODBC continues to give errors, try switching to JDBC. The relevant documentation can be found here: https://www.mathworks.com/help/database/ug/configuring-driver-and-data-source.html

[MEGC]

Switched to JDBC and once I added the correct entry to javaclasspath.txt it is working fine.