Database Connection problem migrating sql query to Matlab 2017

Question

MEGC 2017-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339496-database-connection-problem-migrating-sql-query-to-matlab-2017

评论： MEGC 2017-5-15

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'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Harsh 2017-5-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/339496-database-connection-problem-migrating-sql-query-to-matlab-2017#answer_266856

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