DSN-less Connection To Oracle DB

[Dragenesis]

I'm trying to write a DSN-less connection to an oracle database. Here's what I've got so far.

DIM cnn AS New ADODB.Connection
DIM strOra AS string

strOra = "Provider=OraOLEDB.Oracle;Data Source=Prod;User Id=<username>;Password=<password>;"

WITH cnn
     .connectionstring = strOra
     .open
     END WITH

When I get to opening the connection, it tells me that an object is required. It doesn't say anymore than that. What is wrong with the above code?

 

[RuralGuy]

This link may help: Using DSN-Less Connections