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

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.

Answer 1

[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.