It's not my tutorial. Just I found it some days ago On Tue, Oct 26, 2010 at 9:41 AM, Fredrik TiC Jansson < fredrikjansson1...@gmail.com> wrote:
> Thanks seems rather comprehensive i will go through your tutorial. > > On 26 Okt, 13:18, Rodolinux <rodoli...@gmail.com> wrote: > > 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 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 rubyonrails-talk@googlegroups.com > . > > > To unsubscribe from this group, send email to > > > rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@googlegroups.com> > <rubyonrails-talk%2bunsubscr...@googlegroups.com<rubyonrails-talk%252bunsubscr...@googlegroups.com> > > > > > . > > > 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 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. > > -- 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.