pypyodbc
pypyodbc copied to clipboard
SQL dataype not supported? KeyError -360
I'm trying to run a query on DB2 and get the following error:
...
/opt/conda/envs/DSX-Python35/lib/python3.5/site-packages/pypyodbc.py in execute(self, query_string, params, many_mode, call_mode)
1624
1625 else:
-> 1626 self.execdirect(query_string)
1627 return self
1628
/opt/conda/envs/DSX-Python35/lib/python3.5/site-packages/pypyodbc.py in execdirect(self, query_string)
1652 check_success(self, ret)
1653 self._NumOfRows()
-> 1654 self._UpdateDesc()
1655 #self._BindCols()
1656 return self
/opt/conda/envs/DSX-Python35/lib/python3.5/site-packages/pypyodbc.py in _UpdateDesc(self)
1804 else:
1805 self.description = None
-> 1806 self._CreateColBuf()
1807
1808
/opt/conda/envs/DSX-Python35/lib/python3.5/site-packages/pypyodbc.py in _CreateColBuf(self)
1710 col_sql_data_type = self._ColTypeCodeList[col_num]
1711
-> 1712 target_type = SQL_data_type_dict[col_sql_data_type][2]
1713 dynamic_length = SQL_data_type_dict[col_sql_data_type][5]
1714 # set default size base on the column's sql data type
KeyError: -360
It seems like the datatype is not known by pypyodbc?