Probably that your connection string is incorrect. try
Code:
oconn.Open "Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;"
where 'MyOracleDB' is your Oracle Database,'myUsername' is your Oracle Username and 'myPassword' is your Oracle Password