On Apr 26, 6:26 pm, kimda <tkk...@gmail.com> wrote:
> Hi,
>
> I am been struggling with oracle db connection from RoR app in my new
> windows machine which I was able to it n other windows machine a
> couple of years ago.
> I installed everything (ruby, rubygem and oracle instant client and
> ran ruby oci8 command ) and my RoR web app runs ok except oracle DB
> connection part.
>
> I tested from command line like this:
>
> C:\ruby_old>ruby -r oci8 -e "OCI8.new('username', 'password',
> 'jdbc:oracle
> :thin:@abc.efg.aaa:1521:xxxx).exec('create table testtab (id1 number)'
> ) "
> ruby:0:in `require': no such file to load -- oci8 (LoadError)
>Assuming oci8 is a gem, you'd need to require rubygems before you can require oci8. If you then get the same error as from the rails app then maybe your connect identifier is indeed bust or perhaps oracle needs more stuff setup (I've never used oracle) Fred > from the RoR web app, I get this error: > > ORA-12154: TNS:could not resolve the connect identifier specified > > RAILS_ROOT: ./script/../config/.. > Application Trace | Framework Trace | Full Trace > > env.c:257:in oci8lib.so > C:/web/IPSO/app/controllers/attending_ips_controller.rb:140:in > `get_most_recent_record' > ... > ... > > Am I missing something here? > > thanks in advance, > Daniel > > -- > 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 > athttp://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-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.
