how to connect orange to SQL server

[kixxra]

hi, 

I've tried to connect orange with mySQL server. I've already installed pymsmsql 2.2.5 on my PC, and still can't connect to SQL Server.

btw, my phyton version is 3.7.2. Can it connect to orange? 
Or do I need to downgrade my phyton version??

thanks. 

[ajdapretnar]

We are missing some details. How did you install Orange? Which version of Orange do you have?

[kixxra]

i'd downloaded it from the official site (https://orangedatamining.com/download/#windows), ver.3.33.

[ajdapretnar]

Right. So my guess would be you didn't install pymssql in the proper Orange environment. You need to open Orange Command Prompt and run pip install pymssql in there.

[kixxra]

oh i see, done it, but still got the same error message "please install a backend to use this widget"