Python PYODBC ExecuteMany Failing

-1

I am trying to send data via Python to a Microsoft SQL Database, however, I keep getting the following error when .fast_executemany = True

Process finished with exit code -1073741571 (0xC00000FD)

When I set .fast_executemany = False, the code works, but is much slower. I was wondering if anyone has any suggestions how I can fix this problem?

sql = "INSERT INTO " + table + "(GasDay, FromCountry, Item, 
Model_Country, Point, Status, ToCountry, Value, ForecastDate)" + " 
VALUES(?,?,?,?,?,?,?,?,?)"
sys.setrecursionlimit(10000000)
cnxn = pdb.connect(MetaData.connection_string)
cursor = cnxn.cursor()
cursor.fast_executemany = False
cursor.executemany(sql, tuple)
cnxn.commit()
cursor.close()
cnxn.close()

I'm using Python 3.6.5 and have updated my drivers to the latest version.

Thanks in advance

mysql
python-3.x
pyodbc
asked on Stack Overflow Oct 4, 2018 by user3062960

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0