Connecting to Oracle from Microsoft Excel
found a note that says that Microsoft is no longer supporting MSDAORA which we were using before as the provider, and I installed Oracle Provider for OLE DB 11.2.0.3.0. I am trying to determine what the new connection string will be using OLE DB 11.2.0.3.0. Below is the old connection string code.
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open ( _
"User ID=" & Usercode & _
";Password=" & Password & _
";Data Source=" & Instance & _
";Provider=MSDAORA.1")