pyodbc cursor.executemany() (insert) correctly fills the table but finish with the exit code -1073741571

1

Enviroment:

  1. python-3.6
  2. pyodbc-4.0.23
  3. mssql server 2014

When I use cursor.executemany() with cursor.fast_executemany = False to insert data to MSSQL table it works fine, but too slow (about 1h to write ~100000 rows).

When I use cursor.executemany() with cursor.fast_executemany = True it works fast (about 1m to write the ~100000 rows) and write exactly the same data with the first case but the process finishes with exit code -1073741571 (0xC00000FD) and error <built-in method executemany of pyodbc.Cursor object at 0x000001DE578AA210> returned a result with an error set occurs.

The data for an insert has a structure:

data structure

How can I get the result without having exception?

sql-server
python-3.6
pyodbc
executemany
asked on Stack Overflow Jul 23, 2018 by Alexander Volkov • edited Jul 23, 2018 by L_J

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0