Install python in IRIS

Hello all,

We recently moved our workstations to Windows 10 and so we updated all our local installations to IRIS (servers already run IRIS 2019.1). Now we are trying to connect our pyCharm to IRIS but we can't succeed.

In our ancient Ensemble installation we used intersys.pythinbind3 system, but I realized that with IRIS this is not provided. So I finally found the Welcome to Python QuickStart page (https://learning.intersystems.com/course/view.php?id=1113&ssoPass=1) and I'm trying to connect using pyODBC. But it doesn't work, I found this error when trying to connect (using same code as the examples, just changing the values):

connection = pyodbc.connect(connection_string)
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

 

Then I realized there is this text on the website:  Note: Python is only available on InterSystems IRIS v2019.2+

So, is there anyhing I miss? Or can I go back to use the intersys.pythonbind3 with IRIS so I can continue to work flawlessly?

  • 0
  • 0
  • 122
  • 1
  • 1

Answers

My mistake... the odbc driver name was wrong :'( I can connect now :)

But I see that I have to rewrite the functions because the prepare, execute, fetch, etc attributes doesn't exist in pyODBC :'(

 

UPDATE: just by changing a few lines allowed me to work with pyODBC.

Comments