Re: Unable to connect: Adaptive Server is unavailable or does not exist
Krish <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAJK6VNaefC-NWi2puHc6c9+0Animxk0RvRpNgqwMu4Qa+iRaJA@mail.gmail.com> |
Thanks HTH, I got it worked by setting version = 7.0 on freetds.conf under [global] Krish On Wed, May 8, 2013 at 10:00 AM, James K. Lowden <[email protected]> wrote: > On Tue, 7 May 2013 10:30:48 +0545 > Krish <[email protected]> wrote: > >> The SQL Server is not in localhost, but it is in machine called >> db_server. Access to db_server is restricted to mid_server. I created >> tunnel with >> >> $ssh -L 1433:db_server:1433 user@mid_server >> >> The above port forwardign is working for Navicat. I can connect >> localhost:1433 via Navicat and access all database in db_server. I >> also can telnet localhost 1433. So main problem is freeTDS not working >> port forwarding. Is there any way to get this work? >> >> and my config is: >> >> [sqlserv] >> host = localhost >> port = 1433 >> tds version = 7.0 > > I don't know Navicat, but if that works, then FreeTDS should work, > too. Probably just a small configuration error. > > Try: > > $ TDSVER=7.0 tsql -H localhost -p 1433 > > That should work. If not, you'll have to get ssh to tell you what's > going on. You could also try tracing the Linux system calls. FreeTDS > just opens a TCP connection, nothing fancy, same as telnet. > > If the above command works and "tsql -S" does not, then FreeTDS is not > looking at your freetds.conf file. To see why not, try: > > $ TDSDUMPCONFIG=dump tsql -S sqlserv > > and look at the "dump" file. Usually the output is clear enough to let > the reader diagnose the problem. > > HTH. > > --jkl > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds -- Life is short where is time to hate eachother http://www.krishnasunuwar.com.np ------------------------------------------------------------------------------------ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by person or entity other than the intended recipient is not permitted. If you received this in error, please contact the sender and delete the material from any computer.