As @ronanpeter suggested have you tested the connection from the ODBC Data Source Administrator?
If you’re providing a DSN and using ODBC make sure your ProviderName is set to System.Data.Odbc and not System.Data.OracleClient. What does your connection string look like (minus any passwords)?