cannot use fast_executemany with Informix ODBC driver

mkleehammer / pyodbc

Python ODBC bridge

https://github.com/mkleehammer/pyodbc/wiki

MIT No Attribution

2.92k stars 563 forks source link

cannot use fast_executemany with Informix ODBC driver #989

Closed knight-ni closed 2 years ago

knight-ni commented 2 years ago

Please first make sure you have looked at:

Documentation: https://github.com/mkleehammer/pyodbc/wiki
Other issues

Environment

Python: 3.9
pyodbc: 4.0.32
OS: centos 7.8 (64-bit)
DB: informix
driver: odbc for informix iclit09b.so

Issue

when setting cursor.fast_execmany = True , will cause core dump or Memory Error is there any way to insert by bulk rather than row by row as without fast_execmany did

v-chojas commented 2 years ago

Not all ODBC drivers support the array binding (or even implement it correctly) required to use fast_executemany. You will need to ask your ODBC driver vendor for more information.

gordthompson commented 2 years ago

You might try Turbodbc.