Hi ,
I did all steps given in below link
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