# Problem while connecting MS Sql 2000 from linux

**URL:** <https://www.ruby-forum.com/t/problem-while-connecting-ms-sql-2000-from-linux/174386>\
**Category:** Rails\
**Created:** [August 26, 2009, 7:27am UTC](https://www.ruby-forum.com/t/problem-while-connecting-ms-sql-2000-from-linux/174386 "2009-08-26T07:27:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjayakumar2k6](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/dc4da7/32.png) [@mjayakumar2k6](https://www.ruby-forum.com/u/mjayakumar2k6)\
**Post date:** [August 26, 2009, 7:27am UTC](https://www.ruby-forum.com/t/problem-while-connecting-ms-sql-2000-from-linux/174386/1 "2009-08-26T07:27:12Z")

</div>

Hi ,

I did all steps given in below link

[http://wiki.rubyonrails.org/database-support/ms-sql#dsn-less\_connection](http://wiki.rubyonrails.org/database-support/ms-sql#dsn-less_connection)

And when I connect SQL 200 from my ubuntu 7.10 through SQSH it is  
connecting.

when I try to connect through my rails application it giving error.

DBI::DatabaseError: IM002 (0) [unixODBC][Driver Manager]Data source name  
not found, and no default driver specified  
from  
/usr/lib/ruby/gems/1.8/gems/dbd-odbc-0.2.5/lib/dbd/odbc/driver.rb:36:in  
`connect' from /usr/local/lib/site_ruby/1.8/dbi/handles/driver.rb:33:in `connect’  
from /usr/local/lib/site\_ruby/1.8/dbi.rb:148:in `connect' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/sqlserver_adapter.rb:46:in `sqlserver\_connection’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:262:in  
`send' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection\_without\_query\_cache=’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/query\_cache.rb:54:in  
`connection=' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve\_connection’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection’  
from (irb):1

my database.yml  
development:  
adapter: sqlserver  
mode: ODBC  
dsn: connectsql  
username: sa  
password: process

freetds.conf  
[connectsql]  
host = 10.100.13.11  
port = 1433  
tds version = 8.0

/etc/odbc.ini

[connectsql]  
Driver = FreeTDS  
Description = ODBC connection via FreeTDS  
Trace = No  
Servername = connectsql  
Database = test

/etc/odbcinst.ini

[FreeTDS]  
Description = TDS driver (Sybase/MS SQL)  
Driver = /usr/lib/odbc/libtdsodbc.so  
Setup = /usr/lib/odbc/libtdsS.so  
CPTimeout =  
CPReuse =  
FileUsage = 1

my rails version 1.2.3 and ruby 1.8.6

Thanks in advance  
jK

---

<div class="post-metadata">

**Author:** ![mjayakumar2k6](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/dc4da7/32.png) [@mjayakumar2k6](https://www.ruby-forum.com/u/mjayakumar2k6)\
**Post date:** [August 26, 2009, 2:37pm UTC](https://www.ruby-forum.com/t/problem-while-connecting-ms-sql-2000-from-linux/174386/2 "2009-08-26T14:37:21Z")

</div>

m. jk wrote:

> Hi ,
> 
> I did all steps given in below link
> 
> [http://wiki.rubyonrails.org/database-support/ms-sql#dsn-less\_connection](http://wiki.rubyonrails.org/database-support/ms-sql#dsn-less_connection)
> 
> And when I connect SQL 200 from my ubuntu 7.10 through SQSH it is  
> connecting.
> 
> when I try to connect through my rails application it giving error.
> 
> DBI::DatabaseError: IM002 (0) [unixODBC][Driver Manager]Data source name  
> not found, and no default driver specified

$ping -c3 connectsql

# ?