Ken Foskey wrote:
> On Wed, 2008-05-21 at 23:53 +1000, Ken Foskey wrote:
>> I have a program that will run literally for days and days. It monitors
>> logs by file tail. Problem is that I think the DBI is causing problems.
>> It is constantly connecting and reconnecting to DB2 for every
>> transa
On Wed, 2008-05-21 at 23:53 +1000, Ken Foskey wrote:
> I have a program that will run literally for days and days. It monitors
> logs by file tail. Problem is that I think the DBI is causing problems.
> It is constantly connecting and reconnecting to DB2 for every
> transaction.
The original did
L PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 10:15 AM
Subject: Re: DBI question (again)
>
>
> > good info on using the DBI module (should take you right to prepare):
> > http://theoryx5.uwinnipeg.ca/CPAN/data/DBI/DBI.html#prepare
> >
> > Th
> good info on using the DBI module (should take you right to prepare):
> http://theoryx5.uwinnipeg.ca/CPAN/data/DBI/DBI.html#prepare
>
> There is also a good O'Reilly book titled "Using the Perl DBI" (or
> something like that) by Alligator Descartes
>
I know of the existence of that book but t
>Extracted from the perl cookbook
>
>use DBI;
>
>$dbh = DBI->connect('DBI:driver:database', 'username', 'auth',
>{ RaiseError => 1, AutoCommit => 1});
>$dbh->do($SQL);
>$sth = $dbh->prepare($SQL);
>$sth->execute();
>while (@row = $sth->fetchrow_array) {
># ...
>}
>$sth->finish();
> Elie De Brauwer <[EMAIL PROTECTED]> said:
> use DBI;
> $dbh = BDI->connect('DBI:mysql:databasename:database:host','username','pass')
> or die $DBI::errst;
>
> Now my problem is the following, in order to connect you have to know the
> databasename but I want it to be that the users get a lis
> -Original Message-
> From: Elie De Brauwer [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 31, 2001 9:16 AM
> To: [EMAIL PROTECTED]
> Subject: DBI question ...
>
>
> Hello,
> I have a little problem relating a program that I'm writing.
> This program
> involves getting data from my
Consider this example :
$drh = DBI->install_driver("mysql");
@databases = $drh->func($host, $port, '_ListDBs');
Now the databases will be assigned into "databases" array
Regards,
eDeveloper
- Original Message -
From: "Elie De Brauwer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tu
