> When I said require rubygems I meant that you need to do -rrubygems as > well as -roci8
hm..I am confusing. do you mean updating gems? If so, I just did and still get same error. > Does oracle require any environment variables or configuration files > etc ? I know nothing about oracle > buthttp://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.... > seems to suggest that jdbc:oracle:thin is appropriate when using jdbc, > which you're not. I downloaded oracle instant client and set env classpath. I indeed use jdbc:oracle:thin like this "jdbc:oracle:thin:@xxx.xxx.org:1521:xxxx" Last year, I also remembered that I downloaded ruby-oci8-x.x.x- mswin32.rb and ran on command line and it copied some files under ruby dir. I don't know if this done by gem command these days. On Apr 26, 6:17 pm, Frederick Cheung <[email protected]> wrote: > On Apr 26, 11:08 pm, kimda <[email protected]> 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 > buthttp://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.... > 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 <[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 > > 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.
