/php_troubleshooting_faq.html
which may help you.
cheers
- Original Message - From: Darrell Oresky [EMAIL PROTECTED]
To: dbi-users@perl.org
Sent: Wednesday, September 12, 2007 8:46 PM
Subject: DBD-Oracle Connection Problem
I am having a problem using DBD-Oracle.
Basic problem - I can only get
I am having a problem using DBD-Oracle.
Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.
dbi:oracle:host=xxx;port=yyy;sid='zzz'
Environment:
Remote connection
Server side - Solaris 9, Oracle 9.2.0.4.0
Client side - Solaris 10 i86pc, Oracle
-users@perl.org
Sent: Wednesday, September 12, 2007 8:46 PM
Subject: DBD-Oracle Connection Problem
I am having a problem using DBD-Oracle.
Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.
dbi:oracle:host=xxx;port=yyy;sid='zzz'
Environment:
Remote
On 02/02/07 19:50, Terry Maragakis wrote:
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI-connect(DBI:Oracle:D102L,'scott/tiger','');
Is giving me the error:
DBI connect('D102L','scott/tiger',...) failed:
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI-connect(DBI:Oracle:D102L,'scott/tiger','');
Is giving me the error:
DBI connect('D102L','scott/tiger',...) failed: ORA-12154: TNS:could not
resolve the
@perl.org
Sent: Friday, February 02, 2007 2:50 PM
Subject: DBD Oracle connection problem
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI-connect(DBI:Oracle:D102L,'scott/tiger','');
Is giving me the error:
DBI
PM
To: dbi-users@perl.org
Subject: DBD Oracle connection problem
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI-connect(DBI:Oracle:D102L,'scott/tiger','');
Is giving me the error:
DBI connect('D102L
original email) that may
be related to the problem.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 2:01 PM
To: Terry Maragakis; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
Terry,
I'm a little confused. The error you
, February 02, 2007 1:16 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
I am confused too.
My tnsnames.ora file is fine. I did try sqlplus and tnsping, they both
work. Also, if I do not specify the database name (ORACLE_SID is set to
'D102L') the database handle
]
Sent: Friday, February 02, 2007 3:44 PM
To: Terry Maragakis; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
I saw the warnings, but I don't think they are a problem.
Are you the same user when you execute the Perl program and the sqlplus
command? If not, do you have local
Answered my own question.
$dbh = DBI-connect(dbi:Oracle:dbdev1.mydomain.com:,
The colon at the end was a typo. When fixed, ORA-12154 showed up.
$ENV{ORACLE_HOME} = C:\oracle\ora81;
Big duh. Those backslashes were escaping (\o) twice.
Lessons learned: turn on warnings, and don't just
On WinNT (service pack 6) I've installed:
ActiveState Perl 5.8 (805)
DBI 1.32 and DBD Oracle 1.12 from the ppd's at http://xmlproj.com/PPM/
When running a test connection script (see below) I get Error while
trying to retrieve test for error ORA-06401
I'm running against Oracle 8i (8.1.7). When
12 matches
Mail list logo