ConnectPort X2E ZB - MSSQL - How to write into database ?

Python
, , , ,
1

Hello everyone,

Looking for a way to write data into a database.

With PythonWin (2.7.1) and pyodbc, I can read and write in my database.

I would do the same thing with my ConnectPort X2E ZB.

Unfortunately, i can not run the same code on my gateway.

I get the following error:

File "/userfs/WEB/python/TEST_SQL_1.py", line 9, in 
    import pyodbc
ImportError: No module named pyodbc

Are there other libraries for writing in a MSSQL database with DIGI ESP PYTHON?

Thank you for your help!

2

you’ll have to load pyodbc manually and resolve any dependancies that it raises.