Orange Forum • View topic - Using Python Script widget to run pymssql and SQL server

Using Python Script widget to run pymssql and SQL server

A place to ask questions about methods in Orange and how they are used and other general support.

Using Python Script widget to run pymssql and SQL server

Postby PSmigielski » Sun Oct 16, 2011 21:59

Hi do you think its possible ? When I try to import module (import pymssql) in python script Orange stops.

Piotrek

Re: Using Python Script widget to run pymssql and SQL server

Postby Ales » Mon Oct 17, 2011 9:54

PSmigielski wrote:Hi do you think its possible
It should be possible.
PSmigielski wrote:When I try to import module (import pymssql) in python script Orange stops.
Do you mean orange stops responding (hangs) or simply crashes? On which OS and Python version does this happen?

Re: Using Python Script widget to run pymssql and SQL server

Postby PSmigielski » Tue Oct 18, 2011 7:44

Hi - thanks for the answer,

Its Windows 7 and I have python2.6 version - also I installed pymssql for 2.6. I simply try to load a library in python script with 'import pymssql' then Orange is hanging.

PS

Re: Using Python Script widget to run pymssql and SQL server

Postby Ales » Tue Oct 18, 2011 10:22

Can you try running Orange Canvas from the command line e.g.
Code: Select all
C:\Python26\python.exe C:\Python26\Lib\site-packages\orange\OrangeCanvas.pyw
and then import pymssql in the widget. Maybe some useful info is printed on the console.

P.S. Maybe this is related to http://code.google.com/p/pymssql/issues/detail?id=2


Return to Questions & Support



cron