Sorry I wasn't clear about that. The "ODBC" user has no password, and I have tried a connection strings like

$::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC");
$::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC", "");
$::dbh = DBI->connect ("dbi:ODBC:$dsn", "ODBC", NULL);
[download]

My impression was that if the user "ODBC" is set in the DSN, which it is, then it is not required in the connection string. If it is required, then maybe my problem is that I'm not sure how to enter the password when no password is required. Maybe I should try assigning the ODBC user a password and then I would know the syntax.

Thanks for replying!

Stephen