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.