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;