Oracle in OraClient11g_home1 connection strings

Connects to

Oracle

  • Standard

    Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myUsername;
    Pwd
    =myPassword;
  • Server SID

    Driver={Oracle in OraClient11g_home1};Server=serverSID;Uid=myUsername;
    Pwd
    =myPassword;
  • Both Server and Dbq

    ODBC;Driver={Oracle in OraClient11g_home1};SERVER=[server SID];UID=[userid];
    PWD
    =[password];DBQ=[server SID];

    Some feedback on using both Dbq and Server keywords to make this work.

Problems connecting?
Get answer in the Oracle Q & A forum
ODBC DriverDriver={Oracle in OraClient11g_home1}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.