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

**URL:** https://forums.digi.com/t/connectport-x2e-zb-mssql-how-to-write-into-database/12437
**Category:** Python
**Tags:** python, digi, esp, sql, mysql
**Created:** [January 24, 2014, 5:32am UTC](https://forums.digi.com/t/connectport-x2e-zb-mssql-how-to-write-into-database/12437 "2014-01-24T05:32:49Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![\_GGelec](https://avatars.discourse-cdn.com/v4/letter/_/41988e/32.png) [@\_GGelec](https://forums.digi.com/u/_GGelec)
#### Post date: [January 24, 2014, 5:32am UTC](https://forums.digi.com/t/connectport-x2e-zb-mssql-how-to-write-into-database/12437/1 "2014-01-24T05:32:49Z")

</div>

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:

```auto
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!

---

<div class="post-metadata">

### Author: ![kjensen8](https://avatars.discourse-cdn.com/v4/letter/k/8e8cbc/32.png) [@kjensen8](https://forums.digi.com/u/kjensen8)
#### Post date: [April 11, 2014, 5:49pm UTC](https://forums.digi.com/t/connectport-x2e-zb-mssql-how-to-write-into-database/12437/2 "2014-04-11T17:49:06Z")

</div>

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