Should you not provide the username and password when connecting?
Like $dbh = DBI->connect('dbi:ODBC:DSN', 'user', 'password'); If when you examine the SQL log queries are running as you would expect, please post your code so that someone may point out why it is not displaying the results.