Dear Brian,
I had a problem with ADO/ORACLE that was very similar to yours. My Oracle DB version is 8.1.5, but I´m using Net8 version 8.1.7 and the OLE DB provider version 8.1.7 (the download of these two updates solved my problem). The Connection string I´m using is a bit different from yours, maybe that´s the point!
My code:
adConnection = CREATEOBJECT("ADODB.CONNECTION")
WITH adConnection
.ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist "
.ConnectionString = .ConnectionString + "Security Info=False;"
.ConnectionString = .ConnectionString + "User ID=alonso;"
.ConnectionString = .ConnectionString + "Password=alonso;"
.ConnectionString = .ConnectionString + "Data Source=dbname"
.OPEN()
ENDWITH
Try using "User ID" instead of "userid", "oraOLEDB.Oracle.1" in place of "oraOLEDB.Oracle".
About other configurations, each provider has a set of default properties/parameters, but they also have properties/parameters of its own. Right??
I´m not an expert in ADO, neither oracle, but anything i can do help you, just ask me!
Alonso.
Like Frank said: "I did it... MY WAY!"