I tried to connect to SQL Server from a ROR application in Ubuntu. For that I did the following things.

I installed the following libraries in my Ubuntu 10.04

* unixodbc
* unixodbc-dev
* freetds-dev
* libdbd-odbc-ruby
* tdsodbc

After installing these, I created the dsn and made the required changes in odbc.ini and freetds.conf files.

Then I tested the connection using "tsql" like below

```
tsql -S <dsn name> -U <username> -P <pwd>

```

For this command, I am getting the following error

> 
> `Adaptive Server is unavailable`
> 
> 
> 

I also checked the freetds log; it is saying "connection timedout".

I am sure that we are fine with the configurations (remote) in our SQL Server side.

When I run `tsql -C` it is saying TDS Version is 5. I am not sure how it is saying TDS 5, because I installed the latest FreeTDS version. And I don't know how to update my TDS version.

FYI, I heard that TDS version 5 can't be used for making connections with SQL Server. Is that right? 

Please guide me

Thanks,
Neo