$dbprod = DBI->connect('dbi:ODBC:PROD2', $user, $pass, { RaiseError => 1, odbc_cursortype => 2});

PROD2 is a "System DSN" set up through using the Windows "ODBC Data Source Administrator" clicking on the "With windows NT authentication..." Instead of "With SQL Server authentication..."