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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
