And besides the useful comment already passed, a DSN is not in the form of a hostname, but in the form of a DSN, as the name already suggest, and these differ per database type. I have no idea how that would look for SQL Server 2008 as I don't have that
$dbh = DBI->connect ("dbi:Pg:dbname=test", $usr, $pass, { AutoCommit
+=> 1 });
$dbh = DBI->connect ("dbi:CSV:", undef, undef, { f_dir => ".", PrintE
+rror => 1 });
$dbh = DBI->connect ("dbi:Oracle:host=MADDY", $usr, $pass, { FetchHas
+hKeyName => "NAME_lc" });
$dbh = DBI->connect ("dbi:mysql:database=gigo", $usr, $pass, { RaiseE
+rror => 1 });
$dbh = DBI->connect ("dbi:SQLite:dbname=db/db", "", "", { ChopBlanks
+=> 1 });
Enjoy, Have FUN! H.Merijn