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
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
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'
gem 'mongrel', '1.2.0.pre2'
and then the database.yml
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
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