MGautam wrote:
Hi,
I want to connect to a "Oracle SQL Developer" with perl (running on
windows).
I tried something like,
use DBI;
$db = "database1";
$host = "10.0.0.1:1433";
$user = "username";
$password = "password";
my $dbh = DBI->connect ("DBI:Oracle:database=$db:host=$host",
$user,
$password)
or die "Can't connect to database:
$DBI::errstr\n";
install_driver(Oracle) failed: Can't load
'C:/Perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:The specified procedure could not be found at
C:/Perl/lib/DynaLoader.pm line 202.
Can someone please let me know how to connect to the database. I tried
searching on google. And tried few permutations but none of it worked.
Per an offline email...
You need to install the Oracle client on Windows. SQLDeveloper connects
over JDBC so the client is not necessary. Perl/DBI/DBD::Oracle needs the
client libraries for it connections back to the Oracle database.
HTH
Robert
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
