Oracle in OraClient11g_home1 connection strings

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.