oracle connection problem

[Pradeepta Swain]

Hi ,
I am using oracle client 9.2 ,ruby 1.8.6 and oci8 is installed .but
when i am trying to connect to oracle using the code :


equire 'oci8'
conn = OCI8.new("ftdam", "ftdam","host.string")

it is giving me error like this one :

c:/rubyapps/lib/ruby/site_ruby/1.8/oci8.rb:51:in `init': OCI Library
Initialization Error (OCIError)
from c:/rubyapps/lib/ruby/site_ruby/1.8/oci8.rb:51
from
c:/rubyapps/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`gem_original_require'
from
c:/rubyapps/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
from ip_authenticate_oracle.rb:1

What is the problem and how to fix it .
I am able to connect to oracle using the same user name,password and
host string using sqlplus.

 

[KUBO Takehiro]

Hi,

Hi ,
I am using oracle client 9.2 ,ruby 1.8.6 and oci8 is installed .but
when i am trying to connect to oracle using the code :


equire 'oci8'
conn = OCI8.new("ftdam", "ftdam","host.string")

it is giving me error like this one :

c:/rubyapps/lib/ruby/site_ruby/1.8/oci8.rb:51:in `init': OCI Library
Initialization Error (OCIError) (snip)
What is the problem and how to fix it .
I am able to connect to oracle using the same user name,password and
host string using sqlplus.

A thread in the following link may help you.
http://rubyforge.org/forum/forum.php?thread_id=19973&forum_id=1078