After this command, I still get same error. gem install ruby-oci8 -v 2.0.3 my oracle connect identifier works fine in another windows machine that is prod env. So, I assume oracle stuff is ok.
On Apr 26, 5:10 pm, Frederick Cheung <[email protected]> wrote: > On Apr 26, 6:26 pm, kimda <[email protected]> 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [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.
