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
User contributions licensed under CC BY-SA 3.0