Connecting to a remote Oracle DB

[George Moschovitis]

Hello everyone,

using the ruby Oracle driver I connect to a local db with the following
code:

conn = Oracle.new('username', 'passwd', '')

how can i connect to a remore to a remote database?

I have the ip and port (lets say 10.0.0.1 and 9999)

I tried Oracle.new('username', 'passwd', '10.0.0.1:9999') but this
doesnt work Any ideas?

thanks in advance,
George Moschovitis

 

[Jason Sweat]

Hello everyone,

using the ruby Oracle driver I connect to a local db with the following
code:

conn = Oracle.new('username', 'passwd', '')

how can i connect to a remore to a remote database?

I have the ip and port (lets say 10.0.0.1 and 9999)

I tried Oracle.new('username', 'passwd', '10.0.0.1:9999') but this
doesnt work Any ideas?

thanks in advance,
George Moschovitis

My initial guess is you should add the information to your systems
tnsnames.ora file and refer to it by a symbolic name. Failing that,
you should be able to put a full tns connection descriptor in there. I
am at home now, so I do not have the format handy, but you could
probably google for it.

Regards,
Jason
http://blog.casey-sweat.us/

 

[George Moschovitis]

Failing that,

you should be able to put a full tns connection descriptor in there.

Thank you,

this solved my problem!

regards,
George

 

[George Moschovitis]

Failing that,

you should be able to put a full tns connection descriptor in there.

Thank you,

this solved my problem!

regards,
George