Thanks seems rather comprehensive i will go through your tutorial. On 26 Okt, 13:18, Rodolinux <[email protected]> wrote: > On Tue, Oct 26, 2010 at 5:41 AM, Fredrik TiC Jansson < > > > > [email protected]> 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 fromhttp://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]<rubyonrails-talk%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/rubyonrails-talk?hl=en. > > take a look > athttp://www.10pines.com/content/deploy-ruby-rails-windows-2008-server-... > > 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 [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.
