danishabdullah / pyodbc

Automatically exported from code.google.com/p/pyodbc
Other
0 stars 0 forks source link

Multiple INTs in a Select produce 'HY000' - The driver did not supply a message #226

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Create a table with two integer rows
2. SELECT int_row1, int_row2 FROM table
3. cursor.fetchall() / cursor.fetchone()

What is the expected output? What do you see instead?
I expect a row list or single object with the two queried integers; however, a 
'HY000' exception is thrown on the line with the fetch call

What version of the product are you using? On what operating system?
 SUSE Linux Enterprise Server 10 (x86_64)
 pyodbc-2.1.11-py2.5
 freetds .91
 SQLSERVER 2005

Please provide any additional information below.
 I also remember getting the error if I tried a select where a datetime column was anything but the FIRST column named in the SELECT statement

Original issue reported on code.google.com by nathanpe...@gmail.com on 22 Dec 2011 at 11:20

GoogleCodeExporter commented 8 years ago
Works in 3.0.2-beta05.  Updated one of the FreeTDS unittests in 3.0.2-beta06 to 
include two integers.

Original comment by mkleehammer on 23 Dec 2011 at 7:14