On Apr 26, 11:08 pm, kimda <tkk...@gmail.com> wrote: > After this command, I still get same error. > gem install ruby-oci8 -v 2.0.3 >
When I said require rubygems I meant that you need to do -rrubygems as well as -roci8 > my oracle connect identifier works fine in another windows machine > that is prod env. So, I assume oracle stuff is ok. Does oracle require any environment variables or configuration files etc ? I know nothing about oracle but http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#03_01 seems to suggest that jdbc:oracle:thin is appropriate when using jdbc, which you're not. Fred > > On Apr 26, 5:10 pm, Frederick Cheung <frederick.che...@gmail.com> > wrote: > > > > > > > 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 > > 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 > 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.