comment on

I try the client test.. if I can get a SQL plus client to connect successfully to the remote database from the webserver machine, then, most of my connection worries are solved. IIRC, DBD::Oracle requires that the Oracle client libraries be installed. The easiest way to do this is to actually install the SQL-plus client on the server machine..

Make sure that any user privileges/permissions issues are sorted out, and thereafter,

use DBI;
my $dbh = DBI->connect('dbi:Oracle:host=machine_name;sid=ORCL;port=152
+1', 
  'scott', 'tiger', { RaiseError => 1, AutoCommit => 0 });
[download]

or even the conventional connection method (using the TNS entry) will work.. try these links for some further information... http://www.med.univ-rennes1.fr/~poulique/cours/perl/dbi_oracle.html
http://thomas.eibner.dk/oracle/dbi/

HTH

In reply to Re: Connecting to a remote Oracle database from CGI scripts by tinman
in thread Connecting to a remote Oracle database from CGI scripts by passalack

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


laziness, impatience, and hubris
	PerlMonks