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'
采纳的回答
Harsh
2017-5-12
0 个投票
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:
- 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
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
产品
Translated by 
