This does not do what you think:

DBI->connect("dbi:ODBC:Driver={$ODBCdriver};Server=$SQLserver; Port=$S
+QLport;Database=$SQLdatabase;UID=$SQLuser;PWD=$SQLpassword",
     {PrintError => 0, RaiseError => 1, FetchHashKeyName => 'NAME_lc'}
)
[download]

The second argument to ->connect must be undef or the database user, and the third argument must be the password. The fourth argument can optionally be the connection options, given as a hash.

Your code "works" because you specify user and password in the DSN and that seems to override the arguments given to ->connect.

I would recommend you change your code to the four-argument version.</>