Why do I get an error saying "DECLARE CURSOR is not supported." when connecting to my Azure Synapse Serverless SQL Pool

12 次查看（过去 30 天）
MathWorks Support Team
回答： MathWorks Support Team 2022-7-7
We are trying to access data from an Azure DataLake using the MS SQL ODBC driver in MATLAB R2020a. This works properly with other Database client applications, e.g. DBeaver or from pyodbc, but I haven't found yet how to do this in MATLAB.
We have configured a User DSN (name is DataLakeTest) and we can connect with:
>> conn = database('DataLakeTest', '', '');
But any query gives the following error:
>> Q = 'SELECT * FROM database.table';
>> data = select(conn, Q)
Error using database.odbc.connection/select (line 214)
ODBC Driver Error: ODBC Driver Error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]DECLARE CURSOR is not
supported.

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

采纳的回答

MathWorks Support Team
The following command should resolve the issue you are experiencing with your database:
>> T = fetch(conn,'SET NOCOUNT ON; SELECT * FROM <tablename>')
NOCOUNT is SQL Server specific command. 
SET NOCOUNT ON stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set.
The recommended workaround is to SET NOCOUNT ON before executing a SELECT query. 

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by