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 the SQL Table widget I get what appears to be a dialog box to configure the connection (Server, Database[/Schema], Username, Password) but all of the fields are disabled and the message "Please install a backend to use this widget" appears at the top of the dialog.

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

Any idea how to make this work?

Thanks!

You need psycopg2 (for Postgre SQL) or pymssql (for MySQL) Python packages. — K3---rnc, Jan 07 '17 at 15:59
Thanks for the response K3. I'm trying to connect to a 2012 mssql server. Are you aware of a package for that? — user1038638, Jan 07 '17 at 16:04

score 5 · Answer 1 · answered May 10 '17 at 05:17

5

You must install pymssql and restart the framework.

pip install pymssql

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

answered May 10 '17 at 05:17

GBrian

1,031
11
28

score 0 · Answer 2 · answered Jul 15 '21 at 19:18

0

As per documentation pymssql can connect to MS SQL Server

orange3.readthedocs.io - SQL Table

pymssql

It can connect to PostgreSQL (requires psycopg2 module) or SQL Server (requires pymssql module).

answered Jul 15 '21 at 19:18

LCJ

22,196
67
260
418

How to connect Orange SQL Table widget to Remote SQL Server

2 Answers2