Aca esta..
conn.Open "Provider = MSDAORA;User ID=Usuario;Password=Pass;Data Source=Servidor;"
para mas informacion
echale un
<a href='ir.asp?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdreforacleprovspec.asp' target='_blank'>http://msdn.microsoft.com/library/defaul...</a>
Espero que te sirva....