Connect directly using Microsoft ODBC for Oracle
Connection string
This Microsoft ODBC for Oracle connection string can be used for connections to Oracle.
No TSN nor DSN required.
Driver={Microsoft ODBC for Oracle};
Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=dbName)));
Uid=myUsername;Pwd=myPassword;