pepe wrote in post #968708:
>>
> 
C:/Ruby192/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_support/dependencies.rb:239:in
>> `r
>> equire'
>
> Have you installed the ruby-oci8 gem? (http://ruby-oci8.rubyforge.org/
> en/InstallBinaryPackage.html)

"Hi Thanks for the reply I have found the problem. When I was trying to 
connect to the database I tried
irb>
irb>0>require 'oci8'
irb>0>true
irb>1>OCI8.new('username','password','database name')
irb>1>OCI8(databsename)

the above confirmed that the tns names were working but the when I run 
the rake db:migrate it still says the listener did not recognize the 
service name. Then I looked into the oracle_enhanced_oci_connection.rb 
the connection according to TNS alias was pretty much trying to grab the 
dynamic value I believe from the database.yml then I tried to change the 
connection query
##conn = OCI8.new username, password, connection_string, privilege

        conn = OCI8.new('username','password','databasename')
and executed the command rake db:migrate it made the connection and 
migration was successful

I still do not understand why it happened and is their any permanent 
solution "

-- 
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-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.

Reply via email to