• Oracle

    • New version

      Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;
      Pwd
      =myPassword;
      Oracle
    • Connect 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;
      Oracle
    • Without TSN.ora alternative

      Driver={Microsoft ODBC for Oracle};
      CONNECTSTRING
      =(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=7001))(CONNECT_DATA=(SERVICE_NAME=myDb)));
      Uid
      =myUsername;Pwd=myPassword;
      Oracle

Articlesread all

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.