Skip to Content.
Sympa Menu

freetds - Re: [freetds] MS SQL Server 2008 R2 and freetds 0.82

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: duckdoug AT yahoo.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS SQL Server 2008 R2 and freetds 0.82
  • Date: Fri, 25 Feb 2011 11:07:43 +0100

2011/2/24 Doug <duckdoug AT yahoo.com>:
> 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




Archive powered by MHonArc 2.6.24.

Top of Page