My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 285: FreeTDS SQL Server Invalid data type
1 person starred this issue and may be notified of changes. Back to list
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

Powered by Google Project Hosting