I am trying to use pyodbc to update an existing MS Access database table with a very long multiline string. The string is actually a csv that has been turned into a string. The query I am trying to use to update the table is as follows: The full printed statement looks as follows: However this does not seem t…
Tag: pyodbc
Inser list of ids into table aioodbc (pyodbc)
I am using aioodbc which is basically async pyodbc. My table has only one columns ClaimID. I am trying to do bukl insert list of ids like [1, 2, ,3 ,4 ,5 ,6 … n] (up to 21k) where ids is a python list of ints. I am getting error How to perform bulk insert of list of ids ?
How to access particular elements of a dataframe in Pandas. Gives error
I have a dataframe df_params. It contains parameters for the stored procedure. I simply want to access the elements of the dataframe in a loop: But it gives me an error without really explanation: The goal is to supply value to the stored procedure: desired outcome from print(query): Answer pandas.DataFrames …
Test Connection pyodbc (Python and SSMS)
I’m trying to follow some simple steps in this Microsoft doco but I can get it to connect. What am I doing wrong? This is the error message: PS C:UsersNelson.Silva> & Answer You changed your code before posting. In the code block you say the connect line is but in the exception block the line is:…
pyodbc legacy-install-failure in ubuntu python 3.9
I am not being able to install pyodbc Sorry for the image, but it is on a private network and it does not allow me to do a copy-paste I saw solutions like this, but it is for windows. I can’t downgrade my python 3.9 either. Do you know a solution for this pyodbc installing? Answer Had the same issue
Can python cursor.execute accept multiple queries in one go?
Can the cursor.execute call below execute multiple SQL queries in one go? I don’t have python setup yet but want to know if above form is supported by cursor.execute? Answer Multiple SQL statements in a single string is often referred to as an “anonymous code block”. There is nothing in pyod…
Does not detach database by sp_detach_db in pyodbc
I am trying to detach the database, but for some reason it does not detach with no error, am I missing something? SQLServer 2012 version: 11.0.2100 pyodbc version: 4.0.31 Answer Thx for Gord Thompson for the tip. Fixes: SET SINGLE_USER WITH NO_WAIT -> SET TRUSTWORTHY ON Remove from connect params “Tr…
Python and SQL: Getting rows from csv results in ERROR: “There are more columns in the INSERT statement than values specified in the VALUES clause.”
I have a csv file with several records that I am trying to import into a SQL table via a Python script. My csv file (now reduced to) just one row of 1s. Here is what I am trying to do (after successfully connecting to the database etc etc…): No matter how I format the data in the csv (right
converting python code to python spark code
Below code is in Python and i want to convert this code to pyspark, basically i’m not sure what will be the codefor the statement – pd.read_sql(query,connect_to_hive) to convert into pyspark Need to extract from data from the EDL, so making the connection to the EDL using PYODBC and them extract t…
“Maximum number of parameters” error with filter .in_(list) using pyodbc
One of our queries that was working in Python 2 + mxODBC is not working in Python 3 + pyodbc; it raises an error like this: Maximum number of parameters in the sql query is 2100. while connecting to SQL Server. Since both the printed queries have 3000 params, I thought it should fail in both environments, but…