Windows Oracle Data Access Components (MOSC)

MOSC Banner

Connecting to Oracle from Microsoft Excel

edited Sep 25, 2012 6:26AM in Windows Oracle Data Access Components (MOSC) 5 commentsAnswered
After migrating from Microsoft Excel 2007 to Microsoft Excel 2010, I received the error message "Error 3706 - Provider cannot be found.  It may not be properly installed."

 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")

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center