Issue 285: FreeTDS SQL Server Invalid data type
Status:  Hold
Owner: ----
Reported by cokod...@gmail.com, Sep 8, 2012
I am using Ubuntu. I want to access Microsoft sql database using pyodbc in django. I installed all requirements. 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 ?
Sep 26, 2012
Project Member #1 mkleehammer
Can you attach an ODBC trace for this?  I don't have my Linux test systems available.
Status: Investigating
Sep 27, 2012
Project Member #2 mkleehammer
(No comment was entered for this change.)
Labels: freetds
Sep 27, 2012
Project Member #3 mkleehammer
What is the data type of Id?

Thanks.
Status: Hold
Sep 27, 2012
Project Member #4 mkleehammer
(No comment was entered for this change.)
Labels: -freetds FreeTDS
Sep 29, 2012
Project Member #5 mkleehammer
(No comment was entered for this change.)
Labels: -FreeTDS Driver-FreeTDS
Sep 29, 2012
Project Member #6 mkleehammer
(No comment was entered for this change.)
Labels: -Driver-FreeTDS Driver-freetds