locked
Vb.net OLEDB Provider cannot be found. It may not be properly installed. RRS feed

  • Question

  • Trying to connect to SharePoint using VB.net , every time I try to open the connection string it gives this exception:

    "
     System.Runtime.InteropServices.COMException: 'Provider cannot be found. It may not be properly installed." 

    I tried to changed the CPU in project properties from 64-bit to 32-bit , but its still the same error Note: I tried this code on VBA with the exact connection string and it worked , please help
    With cnt
            .ConnectionString =
    "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;DATABASE=http://*****;LIST={*****};"
            .Open
        End With

    Saturday, June 3, 2017 5:00 AM

Answers

  • I solved it , all I needed id this file :
    https://www.microsoft.com/en-us/download/details.aspx?id=23734

    so I am using Visual Studio 2017 , but I had to install a file versioned in 2007 to solve the problem , brilliant Microsoft !
    • Marked as answer by Mofadl Monday, June 5, 2017 8:41 PM
    Monday, June 5, 2017 8:41 PM

All replies

  • Hi MofadI,

    Please try to the connection string in the code below.

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
    Persist Security Info=False;

    About more info connection string, please refer to

    https://www.connectionstrings.com/access/

    Best Regards,

    Cherry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, June 5, 2017 2:50 AM
  • Which version of Microsoft Office is installed? 32-bit or 64-bit? You should configure the .NET app Platform option with the same version, x86 for 32-bit and Any CPU or x64 for 64-bit.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, June 5, 2017 12:22 PM
  • I solved it , all I needed id this file :
    https://www.microsoft.com/en-us/download/details.aspx?id=23734

    so I am using Visual Studio 2017 , but I had to install a file versioned in 2007 to solve the problem , brilliant Microsoft !
    • Marked as answer by Mofadl Monday, June 5, 2017 8:41 PM
    Monday, June 5, 2017 8:41 PM
  • Would be nice to know what that is. The link goes to a "404 Not Found" page now.
    Friday, August 9, 2019 2:41 PM