pypyodbc icon indicating copy to clipboard operation
pypyodbc copied to clipboard

SQL dataype not supported? KeyError -360

Open PepperJo opened this issue 5 years ago • 0 comments

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?

PepperJo avatar Apr 18 '19 11:04 PepperJo