Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint error.
Microsoft Azure Data Warehouse does not support all of the features of a typical SQL Server or SQL Azure database. Azure Data Warehouse does not support server side cursors, for example. When using a driver such as the Microsoft SQL Server JDBC driver or jTDS JDBC driver to connect to Azure Data Warehouse, the driver needs to be configured to not use cursors or errors will occur on certain queries. An example error if the connection is not configured correctly is the following:
Cursor support is not an implemented feature
for SQL Server Parallel DataWarehousing TDS endpoint.
Error Code: 46706
For example, when using the Microsoft SQL Server JDBC driver, the "selectMethod" connection
property should be set to "direct" instead of "cursor".
When using the jTDS driver, the "useCursors" property should be set to
"false" instead of "true".
If setting up a new connection to Azure DataWarehouse in RazorSQL, select "SQL Azure" as the database type. For the connection type, select the second option: *JDBC (Azure Data Warehouse). RazorSQL will then configure the connection to use the direct method for querying the database instead of using cursors.
To fix a connection that was not set up correctly in RazorSQL, go to the Connections -> Connect menu option, select the Azure Data Warehouse connection, and click "Edit" next to the JDBC URL field. If the field contains selectMethod=cursor, change this to selectMethod=direct. If the field contains useCursors=true, change this to useCursors=false.
