unixodbc and freetds: v 0.62 works, v0.82 not
Jens Carl <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | reventix GmbH |
| Message-ID | <[email protected]> |
Hello List, I recently switched form FreeTDS v0.63 to v0.82 because of the update from Debian Etch to Lenny. The unixodbc version I'm using and MSSQL server I'm connecting are the same. I can establish a connection to server via odbc and sent data to server. But by some of my select statements I get the error message "SQL state: 01000;Native Error Code: 20017;Error Message: [FreeTDS][SQL Server]Unexpected EOF from the server". First I thought that something in my configuration wasn't working so I tried some change to the TDS Version (tried version 4.2, 5.0, and 7.0) and how I connect to the MSSQL server, but that didn't helped. So I made some tests with my select statement and found out that if the statement has a particular length then the error occurred. This is happing when the statement has to be send in more the one message to the server (seen by a tcpdump trace). All the message are sent to server and then server didn't answer and FreeTDS/ODBC is closing the connection with the error. I have seen the post http://lists.ibiblio.org/pipermail/freetds/2009q4/025264.html which had a similar problem so maybe there is already a solution? Best regards Jens