Question about Ruby OCI8

Ruby
1

I tried to use OCI8 to connect Oracle Database.

Code :

require ‘oci8’
conn=OCI8.new(“username”,“password”,"//ip:port/test")

However,something wrong happened :

oci8.c:267:in oci8lib_191.so: ORA-06401: NETCMN: invalid driver
designator (OCIError)

and ip,port and sig, I copied from Oracle’s tnsnames.ora which is right,
so I do not know what’s wrong with this ?

Any help will be appreciated.

2

Bin J. wrote in post #1024209:

I tried to use OCI8 to connect Oracle Database.

Code :

require ‘oci8’
conn=OCI8.new(“username”,“password”,“//ip:port/test”)

However,something wrong happened :

oci8.c:267:in oci8lib_191.so: ORA-06401: NETCMN: invalid driver
designator (OCIError)

and ip,port and sig, I copied from Oracle’s tnsnames.ora which is right,
so I do not know what’s wrong with this ?

Any help will be appreciated.

You need to give more details - platform, version of ruby, version of
ruby-oci8. But this question would be best asked on the ruby-oci8 help
forum:

http://rubyforge.org/forum/forum.php?forum_id=1078