Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip instantclient-basic-OS-VERSION.zip unzip instantclient-sdk-OS-VERSION.zip unzip instantclient-sqlplus-win32-11.1.0.6.0.zip Append the following value to your system path: C:\oracle\instantclient_11_1 Download the following file: http://rubyforge.org/frs/?group_id=256 Run the following from the command prompt: c:\where you saved file>"ruby ruby-oci8-1.0.0-mswin32.rb" Answer "Yes" Assuming that you have previously installed rails 1.x, copy the oracle adapters manually from: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb to: C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters and rename it to oci_adapter.rb Copy the ora.dll & oraociei11.dll from C:\oracle\instantclient_11_1 to c:\ruby\bin Edit your database.yml to read: development: adapter: oci host: <your db host>:<your db port>/<your db sid> username: <uid> password: <pwd> go to http://localhost:3000 expand "About your application''s environment" the Database adapter should read: oci good luck. Next up, trying to get this to work on OSX & Linux. weee, the fun! -- 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Silvio Galea wrote:> Assuming that you have previously installed rails 1.x, copy the oracle > adapters manually from: > C:\ruby\lib\ruby\gems\1.8\gems\activerecord-2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb > to: > > C:\ruby\lib\ruby\gems\1.8\gems\activerecord-1.15.6\lib\active_record\connection_adapters > and rename it to oci_adapter.rbAlternatively, get the new adapter for Rails 2: http://gems.rubyonrails.org/gems/activerecord-oracle-adapter-1.0.0.gem Then run: gem install activerecord-oracle-adapter -l and use "oracle" as the adapter... -- 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
More convenient way to install the Oracle adapter : gem install activerecord-oracle-adapter --source http://gems.rubyonrails.org or check it out from svn: svn co http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/ since Rails 2.0 will not ship with Oracle adapter. 2008/2/23, Mark Bush <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>:> > > Silvio Galea wrote: > > Assuming that you have previously installed rails 1.x, copy the oracle > > adapters manually from: > > C:\ruby\lib\ruby\gems\1.8\gems\activerecord- > 2.0.2\lib\active_record\connection_adapters\oracle_adapter.rb > > to: > > > > C:\ruby\lib\ruby\gems\1.8\gems\activerecord- > 1.15.6\lib\active_record\connection_adapters > > and rename it to oci_adapter.rb > > Alternatively, get the new adapter for Rails 2: > http://gems.rubyonrails.org/gems/activerecord-oracle-adapter-1.0.0.gem > Then run: > gem install activerecord-oracle-adapter -l > > and use "oracle" as the adapter... > > -- > Posted via http://www.ruby-forum.com/. > > > >-- Cheers, Jesse --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---