hi erevy one i use ruby 1.8.7 ,rails is 2.2.2 fisrt get the latest source distribution of Ruby-DBI from: http://rubyforge.org/projects/ruby-dbi/ and copy the file: rub-DBI is 0.2.2 lib/dbd/ADO.rb to: X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb then i install gem install activerecord-sqlserver-adapter -v=2.2.8 i run the server error is establish_connection please install the sqlserver adapter gem install activerecord-sqlserver-adapter no such file to load active_record/connection_adapters/sqlserver_adapter then i copy sqlserver_adapter from ctiverecord-sqlserver-adapter-3.0.0 to that palce but that another error active_support/dependencies.rb:442 in ''load_missing_constant'' uninitialized constant activedrecord::wrappenddatabaseException <name error> Anyone hit this ? Regards, /deng -- Posted via http://www.ruby-forum.com/. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
radhames brito
2010-Sep-14 12:16 UTC
Re: rails connection sqlserver 2005 there some wrong!!
try using bundler to install the gem , it will try to find all the dependencies. http://railscasts.com/episodes/201-bundler On Tue, Sep 14, 2010 at 6:08 AM, Deng Bin <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> hi erevy one > i use ruby 1.8.7 ,rails is 2.2.2 > > > fisrt get the latest source distribution of Ruby-DBI from: > http://rubyforge.org/projects/ruby-dbi/ and copy the file: > rub-DBI is 0.2.2 > > lib/dbd/ADO.rb > > to: > > X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb > > then i install > gem install activerecord-sqlserver-adapter -v=2.2.8 > > i run the server > > error is > establish_connection please install the sqlserver adapter gem install > activerecord-sqlserver-adapter > no such file to load active_record/connection_adapters/sqlserver_adapter > > then i copy sqlserver_adapter from ctiverecord-sqlserver-adapter-3.0.0 > to that palce > > but that another error > > active_support/dependencies.rb:442 in ''load_missing_constant'' > uninitialized constant activedrecord::wrappenddatabaseException <name > error> > > Anyone hit this ? > > Regards, > /deng > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Here is a series of steps that I had to go through in order to get
SQLServer 2005 working for my needs. You might need to skip/replace
some steps. I hope this helps you.
1. Install Ruby (1.8.6): http://www.ruby-lang.org/en/downloads/
2. Install rubygems:
a. http://rubygems.org/pages/download (zip version)
b. Unpack to a directory and cd there
c. ruby setup.rb
3. Install rails: gem install rails –v=2.3.5
4. Install mongrel: gem install mongrel
5. Install mongrel service: gem install mongrel_service
6. Install SQL Server adapter: gem install activerecord-sqlserver-
adapter
7. Install ODBC gem: gem install odbc-rails
8. Install SQL Server Management utility (from Microsoft)
9. Create SQL Server DB
10. Create login in SQL Server
11. Create DB user
12. Create DSN in Windows:
a. Control Panel -> Adminstrative Tasks -> Data Sources (ODBC)
b. Click on System DSN -> Add
c. Select type SQL Server
i. Name: Whichever name you want to give it here.
ii. Description: Your description here
iii. Server: Server name (whichever is the server name you see
in SQL Server Management utility)
iv. Use SQL Authentication
On Sep 14, 6:08 am, Deng Bin
<li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>
wrote:> hi erevy one
> i use ruby 1.8.7 ,rails is 2.2.2
>
> fisrt get the latest source distribution of Ruby-DBI
from:http://rubyforge.org/projects/ruby-dbi/and copy the file:
> rub-DBI is 0.2.2
>
> lib/dbd/ADO.rb
>
> to:
>
> X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb
>
> then i install
> gem install activerecord-sqlserver-adapter -v=2.2.8
>
> i run the server
>
> error is
> establish_connection please install the sqlserver adapter gem install
> activerecord-sqlserver-adapter
> no such file to load active_record/connection_adapters/sqlserver_adapter
>
> then i copy sqlserver_adapter from ctiverecord-sqlserver-adapter-3.0.0
> to that palce
>
> but that another error
>
> active_support/dependencies.rb:442 in
''load_missing_constant''
> uninitialized constant activedrecord::wrappenddatabaseException <name
> error>
>
> Anyone hit this ?
>
> Regards,
> /deng
> --
> Posted viahttp://www.ruby-forum.com/.
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.