Glad to help :)
-Original Message-
From: David Coley [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:19 PM
To: [EMAIL PROTECTED]
Subject: RE: Using DBI when MySQL is on another server
Hey guys I would just like to say thanks... Rinke and Steve both remind my
thick skull
"Can't execute SQL statement : $dbh->errstr";
$sth->bind_columns(undef, \$call_no);
my $row;
while ($row = $sth->fetchrow_arrayref) {
#you get the idea
-Original Message-
From: David Coley [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 8:58 PM
ginal Message-
From: Reinke Bonte [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 10:05 PM
To: David Coley
Subject: Re: Using DBI when MySQL is on another server
I reply private, because I'm not an expert with MySQL. For Oracle at least,
you need to have the Oracle client already in
avid Coley [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:58 PM
To: [EMAIL PROTECTED]
Subject: RE: Using DBI when MySQL is on another server
>From the two responces I've gotten back, I know I didn't phrase this right.
My problem is when I get to the point:
Where is your
nday, February 26, 2001 9:44 PM
To: David Coley; [EMAIL PROTECTED]
Subject: RE: Using DBI when MySQL is on another server
Read DBD::mysql for proper connect statement. One of them should have a
specified location of mysql which can be a network address I believe.
Ilya Sterin
-Original M
> I've looked through the docs on this so I thought I'd go to the horse mouth.
try this:
DBI->connect("DBI:mysql:$db_name:$host",$db_user,$db_password)
or read the doecs (from perldoc DBI)
Examples of $data_source values:
dbi:DriverName:database_name
dbi:
Read DBD::mysql for proper connect statement. One of them should have a
specified location of mysql which can be a network address I believe.
Ilya Sterin
-Original Message-
From: David Coley [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:31 PM
To: [EMAIL PROTECTED]
Subject
