String connection for Microsoft ODBC for Oracle

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)