Select Code to Download

Select or download this

use DBI; 
$DSN = "my_datasourcename"; # Name of the DSN referring to the remote 
+MSSQL-database with IP-adress, logins etc. 
$dbh = DBI->connect("dbi:ODBC:$DSN;or die "$DBI::errstr\n";

Select or download this

use DBI;
# Test code for connecting directly to a remote MSSQL database WITHOUT
+ a predefined data source name... 
...

$DSN = qq|driver={SQL Server (32 bit)};Server=$servername; database=$d
+atabase;port=$port;uid=$username;pwd=$password;|; 
$dbh = DBI->connect("dbi:ODBC:$DSN;host=$hostIP;") or die "$DBI::errst
+r\n";

Select or download this

DBI connect('driver={SQL Server (32 bit)};Server=MSSQL_SERVERNAME; dat
+abase=TempoPlan;uid=username;pwd=password;;host=111.222.333.444;','',
+...) failed: [Microsoft][ODBC Driver Manager] Data source name not fo
+und and no default driver specified