Please help on dbh problem

My config script points to the same server for mysql. How do I get the add.pl script to point to the server where mysql is.

Config file:

sub configure {

########################################

# CGI CONFIGURATION VARIABLES

########################################

$mailprogram = "/usr/sbin/sendmail -t";

$mysqldatabase = "matchpro";

$mysqlusername = "name";

$mysqlpassword = "pass";

Now each file .pl has this line to get to the database:

use DBI;

$dbh = DBI->connect("DBI:mysql:$mysqldatabase", "$mysqlusername", "$mysqlpassword") || die("Couldn't connect to database!\n");

The matchpro mysql is on an other server. Mysql doesn’t run on the server were the script is. How do I call the database??

Can use the help

richard

Reply via email to