Oracle 11g connection string for VB6 ADO

what is the connection string for oracle XE 11g for VB6 ADO ?

The following did not work as suggested on this site...

Driver=OraOLEDB.Oracle;dbq=localhost:1521/XE;Uid=myuser;Pwd=mypassword;

I could connect to XE using my Sql Developer and also using ODBC32.exe system DSN.

1 answer

Driver=Oracle in XE;dbq=localhost:1521/XE;Uid=myusername;Pwd=mypassword;

the above constring worked.