# pyODBC not supporting Dremio decimal

**URL:** <https://community.dremio.com/t/pyodbc-not-supporting-dremio-decimal/609>\
**Category:** Uncategorized\
**Created:** [January 7, 2018, 2:19am UTC](https://community.dremio.com/t/pyodbc-not-supporting-dremio-decimal/609 "2018-01-07T02:19:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Russ\_Wilson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/russ_wilson/32/1507_2.png) [@Russ\_Wilson](https://community.dremio.com/u/Russ_Wilson)\
**Post date:** [January 7, 2018, 2:19am UTC](https://community.dremio.com/t/pyodbc-not-supporting-dremio-decimal/609/1 "2018-01-07T02:19:04Z")

</div>

When i use pyODBC to query a table that contains attributes of type decimal i receive the following error  
(‘ODBC SQL type 0 is not yet supported. column-index=0 type=0’, ‘HY106’)

anyone know of a workarounds?

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [January 7, 2018, 2:46am UTC](https://community.dremio.com/t/pyodbc-not-supporting-dremio-decimal/609/2 "2018-01-07T02:46:01Z")

</div>

Decimal support is still experimental, and is not enabled by default. Unfortunately there’s also a bug in how data is sent to the ODBC driver.

If possible, please use the JDBC driver instead, or wait for our next server release (which should be available very soon).