Microsoft ODBC for Oracle connection strings

Connects to

Oracle

  • New version

    Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;
    Pwd
    =myPassword;
  • 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;
  • 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;
Problems connecting?
Get answer in the Oracle Q & A forum
ODBC DriverDriver={Microsoft ODBC for Oracle}Info and driver downloads

Providers

Connect

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.