Direct connection, no DSN, no TSN:
Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=dbName)));Uid=sqv;Pwd=sqv;
Extract from: http://www.connectionstrings.com/oracle#p17 (very good website)