To connect to the DB, you normally need a connect string. This connect string is usually configured thru "netasst" or by directly editing the tnsnames.ora file.

When you configure the DSN did you specify the Service Name (TNS)?. Try connect to the DB thru SQL*Plus or any other tool by that Service Name.

Try ODBC tracing if nothing helps.