Closed GoogleCodeExporter closed 9 years ago
It works on Windows with the Microsoft ODBC driver and is part of the SQL
Server unit tests. On Linux you would be using FreeTDS I assume. I believe
that's where our difference lies.
Can you generate an ODBC trace on Linux?
Original comment by mkleehammer
on 29 Jul 2011 at 1:12
I'm getting the same 4096 limit for text fields via FreeTDS on ubuntu 10.04. I
get the full result in tsql, but it is truncated in pyodbc. I have attacted an
ODBC trace.
Original comment by CollinMA...@gmail.com
on 3 Aug 2011 at 7:04
Attachments:
I found a way to fix it with free tds in your select statement you
must add the following to it:
SET TEXTSIZE 2147483647
so for instance it would look like: cursor.execute("SET TEXTSIZE
2147483647 select * from blah")
Original comment by dasecret...@gmail.com
on 4 Aug 2011 at 11:47
I found a way to fix it with free tds in your select statement you
must add the following to it:
SET TEXTSIZE 2147483647
so for instance it would look like: cursor.execute("SET TEXTSIZE
2147483647 select * from blah")
Original comment by dasecret...@gmail.com
on 4 Aug 2011 at 11:47
the FREETDS configuration has a set maximum on the returned size of a blob you
can change this in the conf file but it's easier to do what's stated above
Original comment by dasecret...@gmail.com
on 4 Aug 2011 at 11:48
Looks like that worked. Thanks. I also found this stackoverflow explanation:
http://stackoverflow.com/questions/1060035/using-pyodbc-on-ubuntu-to-insert-a-im
age-field-on-sql-server/1073801#1073801
Original comment by CollinMA...@gmail.com
on 4 Aug 2011 at 1:49
It looks like I am also able to fix it by switching TDSVER to 8.0 like so:
os.environ['TDSVER'] = '8.0'
Original comment by CollinMA...@gmail.com
on 4 Aug 2011 at 2:52
Original comment by mkleehammer
on 23 Dec 2011 at 8:13
Original issue reported on code.google.com by
dasecret...@gmail.com
on 25 Jul 2011 at 7:47