remote connection to database

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

hi.
does anyone know if it's possible to connect to a remote oracle 8 database with the dbi module?

having the perl script running on a server with linux and the oracle database running on a remote server with windows nt.

do i need another module other than the dbi to connect to oracle, or is the dbi enough?

thanks,
ralph :)

Comment on remote connection to database

Replies are listed 'Best First'.
Re: remote connection to database by Fastolfe (Vicar) on Oct 14, 2000 at 02:19 UTC
This is precisely what things like DBI and DBD::Oracle are for, so yah. See the documentation for DBD::Oracle for more information. `$dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passwd);` [download]	[reply] [d/l]
Re: remote connection to database by wardk (Deacon) on Oct 16, 2000 at 17:27 UTC
Make sure the local box has Oracle client software, Oracle environment entries (and that these are available to the user running, for instance a webserver client id), and put the remote server in the tnsnames file. Your friendly neighborhood Oracle dba should be able to help get this all worked out. Make friends with your DBA. Maybe find out what his/her favorite beer is :-)	[reply]