|Pathologically Eclectic Rubbish Lister|
Remote Oracle database access from windowsby my600080 (Novice)
|on Jul 24, 2009 at 14:54 UTC||Need Help??|
my600080 has asked for the wisdom of the Perl Monks concerning the following question:
Has anyone had experience of remote access to Oracle database from Windows platform? By doing some research, I found that here are the steps:
1. install active perl
2. install DBI module
3. install DBD::ODBC module
4. install Oracle client on windows.
5. set environment variable (ORACLE_HOME)
Is there anything I've missed? If not, I've done step 1 through 3 but not sure about step4. Should I install Oracle INSTANT client? http://www.oracle.com/technology/tech/oci/instantclient/index.html
But on the installation instruction, it says: All installations REQUIRE the Basic or Basic Lite package.
Do you know what it means? What is Basic or Basic Lite package?
If I finish the installation of Oracle client on my windows, the java connection url for the oracle database is like this:
Using perl, is this what I should do? (can hostname contain port number too?)
my $driver = "ODBC";
my $database = "ORADB";
my $hostname = "10.2.3.0:1521";
my $dsn = "DBI:$driver:database=$database;host=$hostname";
my $dbuser = "oradmin";
my $dbpassword = "oradminpasswd";
my $dbh = DBI->connect($dsn, "$dbuser", "$dbpasswd");
Many thanks to you all!