use DBI;
# Test code for connecting directly to a remote MSSQL database WITHOUT a predefined data source name... 
$database = "TempoPlan"; 
$hostIP = "111.222.333.444"; # Example IP-adress for this post
$port = "1433"; 
$servername = "MSSQL_SERVERNAME"; 
$user = "username"; 
$password = "password"; 

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