Hello i have been atempting to move a project from sqlite database to a sql server database with absolutly no success. i am now going to document my entire process so that mabey someone can se the error of my ways. And if some one else has this problem this migth act as a troubleshooting guide.
OS: windows server 2003 latest sp Sql: Sql server 2008 1. Install ruby 192.p0 from http://rubyinstaller.com/downloads (ticked both boxes ie add to PATH and associate files) installation folder is c:/ruby192 2.Install rails via "gem install rails" 3. Install mongrel via "gem install mongrel --pre" 4. install the sql adapter via "gem install activerecord-swlserver-adapter" 5. install dbd-odbc via "gem install dbd-odbc" this also installed the dbi gem so i wont install this from a separate command Ok now everything i need to start RoR with mongrel and Sql Server should be installed as far as i know on to the gem file gem 'rails'#, '3.0.1' require 'activerecord-sqlserver-adapter' gem 'mongrel', '1.2.0.pre2' require 'dbi' and then the database.yml development: adapter: sqlserver mode: odbc database: NameOfMyDB host: localhost dsn: name_of_my_db autocommit: true username: something password: something Notes about this conf dsn is the same name as the dsn i created with the odbc data source administrator tool this is a system DSN by the way i have also tried with file DSN Ok now on to running my app i go to the directory wich is located as follows D:/projects/railsdev/projectname/ so i go there and execute bundle install the result of this is Error require: no such file to load --activerecord-sqlserver-adapter if i change my require to a gem command everything is installed and the server starts when i try to connect to the database i get another error LoadError (no such file to load --odbc) i have been loosing sleep over this please tell me what am i doing wrong ? -- 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.
