How to connect Orange SQL Table widget to remote SQL Server

Question

I just installed Orange 3.3.9 on my Windows 7 workstation. I'm trying to connect to a remote MSSQL server instance using the "SQL Table" widget in Orange.

When I double-click on the SQL table widget, I get a dialog box for setting up the connection (Server, Database [/ Schema], Username, Password), but all the fields are disabled and the message “Please set the backend to use this widget” appears in top of the dialog box.

I tried adding an ODBC connection to the remote SQL server and restarting Orange, but that didn't help.

Any idea how to make this work?

Thank!

Answer 1

pymssql .

pip install pymssql

https://docs.orange.biolab.si/3/visual-programming/widgets/data/sqltable.html