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
I tested from command line like this:
C:\ruby_old>ruby -r oci8 -e "OCI8.new(‘username’, ‘password’,
:thin:@abc.efg.aaa:1521:xxxx).exec(‘create table testtab (id1 number)’
ruby:0:in `require’: no such file to load – oci8 (LoadError)
from the RoR web app, I get this error:
ORA-12154: TNS:could not resolve the connect identifier specified
Application Trace | Framework Trace | Full Trace
Am I missing something here?
thanks in advance,