08.01.2019 · I have a problem, I have a web app that is using fast_executemany in order to insert into the database. When running it on localhost it works with no problem, but when deploying it to Azure, I get 'pyodbc.Cursor' object has no attribute 'fast_executemany' I am using. Python 2.7; AZURE SQL server DB; pyodbc==4.0.24; The web app is stored in Azure
25.10.2017 · The Cursor.fast_executemany feature introduced in 4.0.18/19 does not seem to handle Unicode characters correctly under Python3 when working with a SQL Server temporary table. The test code import p...
28.10.2020 · Photo by Nextvoyage from Pexels. I’ve been recently trying to load large datasets to a SQL Server database with Python. Usually, to speed up the inserts with pyodbc, I tend to use the feature cursor.fast_executemany = True which significantly speeds up the inserts. However, today I experienced a weird bug and started digging deeper into how fast_executemany really works.
IMHO this is the best way to bulk insert into SQL Server since the ODBC driver does not support bulk insert and executemany or fast_executemany as suggested ...
31.01.2017 · AttributeError: 'psycopg2.extensions.cursor' object has no attribute 'fast_executemany' You are using psycopg2, which is a postgresql driver. This issue and fix pertain to Microsoft SQL Server using the pyodbc driver. SincerelyUnique commented on Jun 26, 2019 what about add 'dtype' parameter FukoH commented on Jul 8, 2019
12.10.2018 · I get the error: File "app.py", line 23, in data cur = mysql.connection.cursor () AttributeError: 'NoneType' object has no attribute 'cursor'. As pointed out by @Martijn Pieters, this means that I could not connect to the mysql database. The question is, why does flask connect without a problem in the first function and has issues with the ...
Explicitly encoding the string value as @veeology mentioned works for me, though I also need to change empty strings to None as @billmccord said — not really viable if you're hoping to preserve the distinction between empty strings and NULLs (I'm pushing data from a pyodbc MySQL cursor to a pyodbc SQL Server cursor).
How I fixed an issue related to “fast_executemany” when loading data to SQL Server ... the connection object to the SQL Server database instance; the cursor ...