Without TSN.ora alternative using Microsoft ODBC for Oracle
Connection string
This Microsoft ODBC for Oracle connection string can be used for connections to Oracle.
Driver={Microsoft ODBC for Oracle};
CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=7001))(CONNECT_DATA=(SERVICE_NAME=myDb)));
Uid=myUsername;Pwd=myPassword;