Thanks guys for all your help. I solved the problem. Here's the code of my connection:

$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 So
+urce Administrator" clicking on the "With windows NT authentication..
+." Instead of "With SQL Server authentication..."
[download]

I it wouldnt work unless I used my NT login and password for $user and $pass. Once again thanks for all your help, your clue made me think more about the problem..... -Fuism