Hello, I''m having a trouble when I try to connect RoR and Oracle. I believe that it has something to do with database.yml, this is how my database.yml looks: development: adapter: oci database: 127.0.0.1:1521/XE username: system password: y1984nip0359 host: 127.0.0.1 And this is the Error that i get: -> http://127.0.0.1:3000/blog OCIError in BlogController#index ORA-12514: TNS:listener does not currently know of service requested in connect descriptor RAILS_ROOT: C:/ruby/bin/blog/script/../config/.. Application Trace | Framework Trace | Full Trace env.c:257:in oci8lib.so Any help? -- 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 -~----------~----~----~----~------~----~------~--~---
Hi Eder, I just wrote a not-so-small Rails app with Oracle and had quite some trouble setting it up, but since then it works flawlessly.> database.yml looks: > development: > adapter: oci > database: 127.0.0.1:1521/XE > username: system > password: y1984nip0359 > host: 127.0.0.1This is mine: development: adapter: oracle database: //localhost:1521/XE username: seek-rat password: seek-rat You could maybe try to change the adapter to oracle. What''s your version of Rails? And the version of your Oracle driver (I had to fiddle around with that quite a bit, though it was under linux)> ORA-12514: TNS:listener does not currently know of service requested in > connect descriptorAre you sure you can connect with the same credentials from Oracle sql-developer (or any other tool creating a connection to the DB)? If yes, probably your ruby-oracle driver has some problems... Cheers, Peter ___ http://www.rubyrailways.com http://scrubyt.org --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
On 10/23/07, Eder Quiñones <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Hello, I''m having a trouble when I try to connect RoR and Oracle. > I believe that it has something to do with database.yml, this is how my > database.yml looks: > development: > adapter: oci > database: 127.0.0.1:1521/XE > username: system > password: y1984nip0359 > host: 127.0.0.1This is mine: development: adapter: oracle database: 127.0.0.1/XE username: myapp_dev password: changeme -- Greg Donald http://destiney.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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
All of these look odd to me. How is your Oracle networking set up? Do you have a tnsnames.ora file? For ''database'', I use the connection name from my tnsnames.ora file. foo_dev: adapter: oracle database: PROD username: foo password: foopass -- Cynthia Kiser --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---