Re: MS SQL Server 2008 R2 and freetds 0.82
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2011/2/24 Doug <[email protected]>: > Hi, > > Have been using freetds 0.64 on 64-bit red hat linux for a long time to connect to MS SQL Server 2000 and MS SQL Server 2005 and it worked fine. > > Recently tried to use it on MS SQL 2008 and SQL 2008 R2 server running Window Server 2008 R2 Enterprise (64 bit). The SQL servers do not have encryption turned on. In both cases, it was able to connect and could do simple short queries. However when tried to run a long running query (a simple update), the query would start and after a while, it would return an error stating "read from server failed" and the connection is dropped. Tried that with freetds version 0.82 and compiled with TDS version 8.0 and ran into the same issue. > > > Any help is greatly appreciated! Thanks. > > Doug > It's a known problem related to a mis-detected timeout reported as a read error. Use post 0.82 patches (http://freetds.sourceforge.net/) or patched version. bye freddy77 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds