FreeTDS SQL Server Invalid data type

Question

I am using Ubuntu. I want to access Microsoft sql database using pyodbc in django. I installed all requirements. To do that, I wrote this

cursor.execute('SELECT Id FROM %s' %table_name) 

I am getting error which is

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

But, when I try this

cursor.execute('SELECT * FROM mytable')

It works fine. Why do I see that error, Is there a way to solve that issue ?

Answer 1

SQL Server doesn't support variables for table names. Try building the whole statement as a string and then executing it.