Re: tsql connects but prompt incs 1, 2, 3

"Ryp Walters" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Organization OverCoffee Productions
Message-ID <04f401cb916c$9ddb6dd0$1101010a@Marvinii>
Turns out that it is a 'feature' of tsql.  I assumed that because I got the
password prompt that I had successfully connected to my remote MSSQL db.  In
reviewing tsql.c file, the connection attempt starts afterwards.

I verified via telnet that I was NOT able to access to remote server.  Once
that was resolved, tsql works like a charm.

For whoever keeps the User Guide updated, would you please update these
pages:
http://www.freetds.org/userguide/confirminstall.htm
http://www.freetds.org/userguide/serverthere.htm
http://www.freetds.org/userguide/usefreetds.htm (optional)

I suggest the following:

After prompting for the password, tsql will attempt to connect to the remote
server.  Tsql will display a counter indicating the number of seconds that
it is attempting to connect.  Typically, tsql should immediately respond
with a '1>' prompt.  If you see the counter (1, 2, 3, ...), most likely tsql
is unable to connect to your database.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.