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.