On Mon, Nov 01, 2004 at 12:55:18PM -0600, Mullen, David A wrote:
>
> If I first do DBI->connect() to the Oracle 9i database, and then to DB2
> (without retrieving data from either, but having prepared some
> statements), it works fine. However, if I set up the DB2 $dbh and
> statements first, I ge
Hi all,
We're having a strange problem with a number of perl scripts we use to
verify the synchronization of an Oracle database with a DB2 database.
We're running perl 5.8.5 on HP-UX 11 (had to do our own compile; used
gcc). DBI version is 1.45, DBD::Oracle is 1.16 (client version 9.2.0.5),
DBD::D
Wed, 12 Feb 2003 10:24:49 -0800
> From: Eddie Bradford <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: Can't Connect to Oracle 9i Database
>
> I've written a perl program and I'm trying to connect to a 9i data
I've written a perl program and I'm trying to connect to a 9i database
as user 'sys', which requires the 'as sysdba' clause. Using the
dbi->connect
method fails with everything I've passed it. What's the secret?
Eddie Bradford
Systems Analyst/Programmer
Information Technology Services
John Muir/
thanks!
i've managed (the instance name was different in tnsnames.ora)
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 7:29 PM
To: [EMAIL PROTECTED]; Moshe Rivel
Subject: Re: can't connect to oracle
On Sun, 12 Jan 2003 18:0
On Sun, 12 Jan 2003 18:09:33 +0200 Moshe Rivel <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Moshe Rivel [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 12, 2003 10:47 AM
> To: 'Michael A Chase'; '[EMAIL PROTECTED]'
> Subject: RE:
ginal Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 6:06 PM
To: 'Moshe Rivel'; 'Michael A Chase'; [EMAIL PROTECTED]
Subject: RE: can't connect to oracle
Hmmm, you might want to check and make sure that you are running the
script
unday, January 12, 2003 10:47 AM
To: 'Michael A Chase'; '[EMAIL PROTECTED]'
Subject: RE: can't connect to oracle
(guess i don't have to mention i'm a DBI newbie, so thanks for your
patience)
this is a test script (btw, 'make test' worked fine when installin
DBI::END
-> disconnect_all for DBD::Oracle::dr
(DBI::dr=HASH(0x8186828)~0x81ecc48)
<- disconnect_all= '' at DBI.pm line 575 via ./db_connect.pl line 0
dbih_clearcom 0x8186828 (com 0x81088a8, type 1) done.
<> DESTROY for DBI::dr=HASH(0x8186828) ignored (inner handle gone)
On Sun, 12 Jan 2003 17:19:09 +0200 Moshe Rivel <[EMAIL PROTECTED]> wrote:
> yes i can
>
> -Original Message-
> From: Michael A Chase [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 12, 2003 5:25 PM
> To: '[EMAIL PROTECTED]'; Moshe Rivel
>
yes i can
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 12, 2003 5:25 PM
To: '[EMAIL PROTECTED]'; Moshe Rivel
Subject: Re: can't connect to oracle
On Sun, 12 Jan 2003 16:49:40 +0200 Moshe Rivel <[EMAIL PROTECTED]> w
On Sun, 12 Jan 2003 16:49:40 +0200 Moshe Rivel <[EMAIL PROTECTED]> wrote:
> oracle 9.0.1
> linux RH 7.1
> DBI connect('ora901','system',...) failed: ORA-12154: TNS:could not resolve
> service name (DBD ERROR: OCIServerAttach) at ./db_connect.pl line 4
> DB connect not made: ORA-12154: TNS:could no
oracle 9.0.1
linux RH 7.1
DBI connect('ora901','system',...) failed: ORA-12154: TNS:could not resolve
serv
ice name (DBD ERROR: OCIServerAttach) at ./db_connect.pl line 4
DB connect not made: ORA-12154: TNS:could not resolve service name (DBD
ERROR: O
CIServerAttach) at ./db_connect.pl line 4.
tha
On 10 Jul 2002 05:27:14 - Mark Murphy <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] (Michael A Chase) wrote in
> Mahogany-0.64.2-2324-20020709-102955.00@MCHASE-COMPAQ:">news:Mahogany-0.64.2-2324-20020709-102955.00@MCHASE-COMPAQ:
>
> Correction If you are using Apache and running the script
[EMAIL PROTECTED] (Michael A Chase) wrote in
Mahogany-0.64.2-2324-20020709-102955.00@MCHASE-COMPAQ:">news:Mahogany-0.64.2-2324-20020709-102955.00@MCHASE-COMPAQ:
> On Tue, 9 Jul 2002 09:03:42 -0400 "Kakli, Samir (S.A.)"
> <[EMAIL PROTECTED]> wrote:
>
>> I'm having the following problem using D
On Tue, 9 Jul 2002 09:03:42 -0400 "Kakli, Samir (S.A.)" <[EMAIL PROTECTED]> wrote:
> I'm having the following problem using DBI. My perl version is 5.005,
> and Oracle.pm version is 1.47. Can you help?
That internal version number doesn't necessarily change with DBD::Oracle
versions. The DBD:
Hello,
I'm having the following problem using DBI. My perl version is 5.005, and Oracle.pm
version is 1.47. Can you help?
Samir
-CGI script
use DBI;
use CGI;
$ENV{ORACLE_HOME}='/ford/thishost/unix/cen/oracle/v7/7.3.2';
$OracleUser = 'e01';
$OraclePasswor
It won't be a problem as long as your ORACLE_HOME variable
points to the 8i oracle installation and not a 9i installation.
Jared
On Wednesday 03 July 2002 14:06, Tim Harsch wrote:
> I have a connection problem:
> DBI->connect(BBRP.LLNL.GOV) failed: ERROR OCIEnvInit at
> disable_all_foreign_keys
I have a connection problem:
DBI->connect(BBRP.LLNL.GOV) failed: ERROR OCIEnvInit at
disable_all_foreign_keys.pl line 32
% perl -MDBI -MDBD::Oracle -MDBD::Sybase -le 'print "$DBI::VERSION
$DBD::Oracle::VERSION"'
1.14 1.06
% uname -a
SunOS trna 5.8 Generic_108528-11 sun4u sparc SUNW,Sun-Fire-880
19 matches
Mail list logo