On Tue, Oct 26, 2010 at 5:41 AM, Fredrik TiC Jansson < fredrikjansson1...@gmail.com> wrote:
> 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 rubyonrails-t...@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > take a look at http://www.10pines.com/content/deploy-ruby-rails-windows-2008-server-and-iis-70 greets -- http://www.rodolinux.com.ar "I must not fear. Fear is the mind-killer. I will face my fear. I will permit it to pass over me and through me. And when it has gone past I will turn the inner eye to see its path. Where the fear has gone there will be nothing. Only I will remain." - Bene Geserit's Fear Lethany - Dune Trilogy - Frank Herbert -- 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 rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.