OLE DB Provider for Oracle (from Microsoft) Oconn.open "provider = msdara;" & _ "Data Source = Myoracledb;" & _ "User ID = myusername;" & _ "password = mypassword;"
OLE DB Provider for Oracle (from Oracle) for Standard Security: Oconn.Open "provider = oraoledb.oracle;" & _ "data source = myoracledb;" & _ "user id = myusername;" & _ "password = mypassword;" For a trusted connection: Oconn.open "provider = oraoledb.racle;" & _ "data source = myoracledb;" & _ "user ID = /;" & _ "password =;" 'or opinn.open "provike = oraoledb .Oracle; "& _" data source = myoracledb; "& _" osauthent = 1; "
