Skip to Content.
Sympa Menu

freetds - Re: [freetds] Weird tsql behaviour

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: "James K. Lowden" <jklowden AT freetds.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Weird tsql behaviour
  • Date: Sat, 30 Jan 2016 18:57:19 +0000

2016-01-30 18:21 GMT+00:00 James K. Lowden <james.k.lowden AT icloud.com>:
> On Fri, 29 Jan 2016 20:54:44 +0000
> "Thomas, Christopher (LLU)" <cwthomas AT llu.edu> wrote:
>
>> Once I connected to the database server using tsql, the line numbers
>> started to go up and up, automatically. About one digit per second.
>
> Those "line numbers" are a counter that appears while a connection
> request is pending. It disappears when the connection succeeds. And,
> yes, they should be really, really close to 1 second apart! ;-)
>
> Under the hood, libtds connects to the server using nonblocking I/O.
> connect(2) usually returns with EINPROGRESS or similar, and the library
> uses poll(2) to wait for the connection to complete. You can see
> evidence of that in a typical TDSDUMP log.
>
> The above information should be in the man page, but isn't. Sorry
> about that, Chief.
>

So looks like your server is down. Or firewall/network problems. Or
sql server is not accepting new connections. If the physical server is
up but sql server is down you should see a fast reply with connection
error.

Frediano




Archive powered by MHonArc 2.6.24.

Top of Page