Hi,
I am writing some report in perl to retrieve records from database. And
every time when make a connection to database will take a long time.
How can I make my script to
1. if the database connection is not there, make a connection from
web server and database
2. if database c
At 18:45 -0500 6/7/02, Danny wrote:
>Danny writes:
>>
>>I just upgraded to redhat 7.3 and am now having this problem when I
>>try to read my /home/dwrice/.my.cnf file.
>>
>>perl -we 'use DBI;DBI->trace(2);my $dsn =
>>"DBI:mysql:dwrice;mysql_read_default_group=client;mysql_read_default_file=$ENV{H
Danny writes:
>
>I just upgraded to redhat 7.3 and am now having this problem when I
>try to read my /home/dwrice/.my.cnf file.
>
>perl -we 'use DBI;DBI->trace(2);my $dsn =
>"DBI:mysql:dwrice;mysql_read_default_group=client;mysql_read_default_file=$ENV{HOME}/.my.cnf";my
> $dbi = DBI->connect($dsn
how would changing double quites to single quites help in this case?
make sure that you can connect to the oracle server with sqlplus with same
username/password and tns name
this will look like something like sqlplus scott/tiger@ORACLE
Hope this helps
Anton
-Original Message-
From: Kot
$dbh = DBI->connect("dbi:Oracle:ORACLE","scott", "tiger",
Change to
$dbh = DBI->connect("dbi:Oracle:ORACLE",'scott', 'tiger',
--Raju
-Original Message-
From: Kotha, Nagaraju [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 3:51 PM
To: 'Roger Patrick'; [EMAIL PROTECTED]
Subject:
Try with set up ORACLE_HOME environment var in your script:
$ENV{ORACLE_HOME} = '/local/oracle/8.1.7/...';
--Raju
-Original Message-
From: Roger Patrick [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 1:23 PM
To: [EMAIL PROTECTED]
Subject: Problem with Oracle DBD on client serv
After installing the Oracle DBD for DBI, on a client Solaris 8 (Intel) server I ran
the following script and received this error:
#!/usr/bin/perl -w
use DBI;
my ($sth, $dbh, @row);
unlink 'dbitrace.log' if -e 'dbitrace.log';
DBI->trace(5, 'dbitrace.log');
$dbh = DBI->connect("dbi:Oracle:ORACL
follow up
Here is full log:
<>
Here is output of perl -V:
<>
any help appreciated.
Thx,
Tom.
> -Original Message-
> From: Ziem,Thomas IT BIP-US-R
> Sent: Friday, June 07, 2002 11:48 AM
> To: [EMAIL PROTECTED]
> Subject: DBD on HP-UX, Oracle 9 rel. 2
>
>
> get
This distribution has been tested as part of the cpan-testers
effort to test as many new uploads to CPAN as possible. See
http://testers.cpan.org/
Please cc any replies to [EMAIL PROTECTED] to keep other
test volunteers informed and to prevent any duplicate effort.
--
Summary of my perl5 (rev
Ilya,
Would you make a ppd of the current DBD::ADO (2.5) and post it to
your site please? The DBD::ADO does not appear to be available
from ActiveState.
Tom
--
Thomas A. Lowery
See DBI/FAQ http://xmlproj.dyndns.org/cgi-bin/fom
On Fri, 7 Jun 2002 11:53:33 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
>> I load DBI and DBD in each thread, in an "eval" statement, hoping
>> that that will force separate loading for each thread (am I wrong?);
>
>Depends on how you're doing it.
In the sub that is called at thread creation, I
getting the following error for DBD make:
tdapp01 $ make
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH="/u01/home/oracle/product/9.2.0/lib" ld -b
+vnocompatwarnings -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o
/u01/home/oracle/produc
On Thu, 2002-06-06 at 18:16, Tim Harsch wrote:
> I guess my reluctance to turn off AutoCommit in all my connects by
> default comes from lack of understanding of the different DBMS'. I know
> Oracle can handle a huge number of updates if place holders are used.
> I'm not sure about Sybase. I do
On Fri, Jun 07, 2002 at 11:12:41AM +0200, Jrmy JUST wrote:
>
> Thank you for your answer. I should have read the new doc...
>
> >It is I safe to have multiple threads load
> >the DBI module I they have been created, but the DBI probably
> >won't be providing any protection against multiple th
Same results a few hours ago.
I sent it to Tim and he came up with "DBI->trace(0, undef);" placed before "ok(-s
$logfile);".
It flushes the output and closes the file before we are testing the size.
-- Petr Smejkal
> -Original Message-
> From: Ian Crowley [mailto:[EMAIL PROTECTED]]
>
I just upgraded to redhat 7.3 and am now having this problem when I
try to read my /home/dwrice/.my.cnf file.
perl -we 'use DBI;DBI->trace(2);my $dsn =
"DBI:mysql:dwrice;mysql_read_default_group=client;mysql_read_default_file=$ENV{HOME}/.my.cnf";my
$dbi = DBI->connect($dsn,undef,undef) || die
I'm having trouble with obtaining locks on tables with a DBI script. I
have the following function which has been run at the beginning of a
long running script. However, after starting the script I am able to go
into sqlplus and obtain exclusive locks on the tables in question.
I'm sure it has
Hi
I can confirm the warnings are now gone on the make for win2000...and the
make went fine.
The make test fell over again at the same spot ... profile and subsequently
crashed completely
Did some investigation and found that the lines below aren't sufficient (for
win2000 anyway)...a check o
Thank you for your answer. I should have read the new doc...
>It is I safe to have multiple threads load
>the DBI module I they have been created, but the DBI probably
>won't be providing any protection against multiple threads entering a
>databases own library code. As many databases don't
19 matches
Mail list logo