I am having problems connecting to a new Oracle 11g database through QTP. I can connect and query the database fine through the likes of TOAD on my machine - but QTP is throwing the following error:

"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"

Using the following code:

Set oDb = CreateObject("ADODB.connection")
sDbConnString = "Driver={Microsoft ODBC for Oracle};UID=" & sUsername&";PWD=" & sPassword & ";SERVER=" & sDbServer&";"
oDb.open sDbConnString

As mentioned before, I am using exactly the same username / password / Server through TOAD and that is working fine...

Thanks for any help