Hi all,

I am an absolute newbie to DBI and have read the documentation and am
still unsure.

I am attempting to connect to a SQL7 DB that is on a server other than
the webserver.  I am unsure as to what the connection string will be?

use DBI;

my $dbh = DBI->connect ("DBD:mSQL:database=<DB_NAME>;host=<HOST_NAME>",
"<USER>", "<PWD>", {PrintError => 1}) or die "Cant connect:
$DBD:errstr\n";
$dbh->disconnect or warn "Connection could not terminated..\n";
exit;

I keep getting the following error?

Can't connect(DBD:mSQL:database=...;host=... ... ... HASH(0x25714d0)),
no database driver specified and DBI_DSN env var not set at
Z:\InetPub\scripts\driver.pl line 3

I really appreciate your help with this
Thanks

Neil Barlow

Reply via email to