Problem with connecting to an Oracle database using Perl
From: Charles Lawrence (charles.lawrence_at_swifttel.net)
Date: 01/18/05
- Next message: Sing Manickam: "installing DBI"
- Previous message: Graeme St. Clair: "RE: Oracle SQL Comparison"
- Next in thread: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Ron Reidy: "RE: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Graeme St. Clair: "RE: Problem with connecting to an Oracle database using Perl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 18 Jan 2005 14:54:41 -0500 To: <dbi-users@perl.org>
Gentlemen:
I have struggled with this problem for a while now with no success at
finding the answer, so I am asking for help from anyone who might know
the solution.
I am using Windows XP, ActiveState Perl 5.8.4, Oracle 9.2.0.1.0 client
and server, DBI (1.45) and DBD-Oracle (1.16) installed as ppm packages
from ftp.esoftmatic.com/outgoing/DBI/5.8.4/
I do not have a problem connecting to the remote database using the
Oracle Enterprise Manager program from my PC. However, I am getting the
following error when I try to connect to the database from perl:
DBI connect('host=10.1.10.61;sid=ssdb','system',...) failed: ERROR
OCIInitialize. Check ORACLE_HOME and NLS settings etc. at
D:\PerlScripts\ora1.
pl line 17
Unable to connect to database: ERROR OCIInitialize. Check ORACLE_HOME
and NLS settings etc.
My perl script is:
#!/usr/bin/perl
use strict;
use DBI;
use DBD::Oracle qw(:ora_session_modes); # ORA_SYSDBA & ORA_SYSOPER
constants
my ($dsn,$usr,$pwd);
my ($dbh);
$ENV{NLS_LANG} = 'american';
$ENV{ORACLE_HOME} = 'D:\Oracle\ora92';
# connect to remote Oracle DB
$dsn='DBI:Oracle:host=10.1.10.61;sid=ssdb';
$usr='system';
$pwd='manager';
$dbh = DBI->connect($dsn,$usr,$pwd) || die "Unable to connect to
database: $DBI::errstr\n";
I have used NLS_LANG settings of 'american_america.we8iso8859p1' and
'american_america.utf8' to no avail. I know the ORACLE_HOME to be
correct. I cannot figure out why I am getting the OCIInitialize error.
Any help will be greatly appreciated. Thanks in advance.
Charles Lawrence
charles@swifttel.net
- Next message: Sing Manickam: "installing DBI"
- Previous message: Graeme St. Clair: "RE: Oracle SQL Comparison"
- Next in thread: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Hardy Merrill: "Re: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Ron Reidy: "RE: Problem with connecting to an Oracle database using Perl"
- Maybe reply: Graeme St. Clair: "RE: Problem with connecting to an Oracle database using Perl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
