python: Invalid data type (0) (SQLBindParameter)

Question

I am using python 2.7 for a specific job. I am connecting to MSSQL Server (2008) using FreeTDS. I can make some simple select queries but when I try to run a parametrised query I got an error:

('HY004', '[HY004] [FreeTDS][SQL Server]Invalid data type (0) (SQLBindParameter)')

Here is my query:

query = u"UPDATE table SET column1=? WHERE column2=?"
cursor.execute(query,[param1, param2])

However the same code on live works fine.

I have skimmed so many thread in various forums but they all seem misleading and I am really confused.

What is my actual problem and what do you suggest?

Edit: I've added query.

Please share the actual code, including the query you tried to execute. — Martijn Pieters, Nov 09 '12 at 15:48
@Martijn Pieters thanks for your interest I've updated question with query. — huzeyfe, Nov 09 '12 at 15:58
Oh sorry I was supposed to say that param1 unicode string (), param2 is an integer. — huzeyfe, Nov 09 '12 at 16:01
It might be the same issue here http://stackoverflow.com/questions/947077/using-pyodbc-on-linux-to-insert-unicode-or-utf-8-chars-in-a-nvarchar-mssql-field — Faruk Sahin, Nov 09 '12 at 16:04
@Faruk Sahin Thanks for you response however I already read that post with no luck.. — huzeyfe, Nov 09 '12 at 16:19
@huzeyfe Curious, what are the data types on `column1` and `column2` in SQL Server? — Bryan, Nov 09 '12 at 18:37

score 10 · Accepted Answer · answered Oct 09 '19 at 19:14

10

I know this is a super old thread, but I came across this same problem and the solution for me was to type cast the variables. For instance:

query = u"UPDATE table SET column1=? WHERE column2=?"

cursor.execute(query,[str(param1), str(param2)])

In this case it doesn't really matter what type the parameters are as it will be converted to a string.

answered Oct 09 '19 at 19:14

Matt Binford

620
8
15

1

This was *very* helpful – Plato77 Sep 18 '20 at 17:46
2

Funnily enough, here I am 2 years later and ran into the same issue and found my own answer.. Can't upvote myself though.. – Matt Binford Jun 08 '21 at 18:01

python: Invalid data type (0) (SQLBindParameter)

1 Answers1

Linked