Microsoft ODBC for OracleConnect directly

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;

Connecting

This connection string (Connect directly using Microsoft ODBC for Oracle) can be used for connections to Oracle.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.