querychat not working with SqlServer

[MacBurt]

Error in querychat_init():
! ODBC failed with error 42000 from [Microsoft][ODBC SQL Server Driver][SQL Server].
✖ Incorrect syntax near '1'.
• 'SELECT * FROM "planning"."OpsAppSched" LIMIT 1'
ℹ From nanodbc/nanodbc.cpp:1726.

I tried everything I could think of. I could not get SqlServer to work.

[cpsievert]

Hi @MacBurt, thanks for reporting. To help us diagnose, is there a way you could share some R code to query the table of interest directly with DBI (i.e., no querychat involved)?