none
Working VB.Net desktop program getting error 3706 provider not found.when trying to connect via ODBC/ADO to Excel 32 bit (Office365) RRS feed

  • Question

  • We have a working VB.Net app that connects to an Excel file using DSNLess ODBC/ADO.  It has been working for years with the normal installed office (2010, 2013, etc) 32 bit excel. 

    However for Office 365 if fails with an error 3706 provider not found.  This has occurred on several systems.  We cannot get it to work on any Office365 system.

    Excel is still 32 bit.  Our App is 32 bit.

    connection string

    Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='C:\Users\Lisa\Desktop\BuySell Program\Database.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES"

    Any Ideas???


    Jack / QuickBooks Programming

    Friday, April 1, 2016 5:46 PM

Answers

  • Hi Jack,

    Did you install the Access on the computer?

    To query the data from Excel using ADO.Net, we need to using the correct data provider. Normally it will be installed with the Access. You can refer to the figure below about more detail about the architecture of the ACE engine in the data access programming environment:

    And to connect the ACE Engine successful using 32-bit application, we should install the 32-bit Access on the computer.

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, April 4, 2016 1:46 AM
    Moderator
  • Hi Jack,

    Sorry for the confusion. We need to connect the Excel through the ACE engine or other database which supports using the spreadsheets as data source.

    And the ACE engine also is included in the Access run time. If you don't want to install the Access product, you can also try to install the Access run time. 

    Here is the link for your reference:
    https://www.microsoft.com/en-us/download/details.aspx?id=39358

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, April 5, 2016 9:06 AM
    Moderator
  • The access runtime 2013 32 bit seems to work:-)

    Not sure why it now had to be installed while before it did not.


    Jack / QuickBooks Programming

    • Marked as answer by JackQB Tuesday, April 5, 2016 1:18 PM
    Tuesday, April 5, 2016 11:56 AM

All replies

  • Hi Jack,

    Did you install the Access on the computer?

    To query the data from Excel using ADO.Net, we need to using the correct data provider. Normally it will be installed with the Access. You can refer to the figure below about more detail about the architecture of the ACE engine in the data access programming environment:

    And to connect the ACE Engine successful using 32-bit application, we should install the 32-bit Access on the computer.

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, April 4, 2016 1:46 AM
    Moderator
  • No Access, never had to install Access in the other installs that are working.  This always had worked until Office365.

    Need a solution without Access.

    Isn't there some type of run-time that can be used without Access itself? 

    I am probably missing some module but I just don't know what it is.


    Jack / QuickBooks Programming

    Monday, April 4, 2016 9:45 AM
  • Hi Jack,

    Sorry for the confusion. We need to connect the Excel through the ACE engine or other database which supports using the spreadsheets as data source.

    And the ACE engine also is included in the Access run time. If you don't want to install the Access product, you can also try to install the Access run time. 

    Here is the link for your reference:
    https://www.microsoft.com/en-us/download/details.aspx?id=39358

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, April 5, 2016 9:06 AM
    Moderator
  • I believe that I tried these already. Not clear since the file names are the same.

    Also it is a 64 bit machine and windows but Excel and the App is 32 bit so which is to be installed?


    Jack / QuickBooks Programming

    Tuesday, April 5, 2016 10:38 AM
  • The access runtime 2013 32 bit seems to work:-)

    Not sure why it now had to be installed while before it did not.


    Jack / QuickBooks Programming

    • Marked as answer by JackQB Tuesday, April 5, 2016 1:18 PM
    Tuesday, April 5, 2016 11:56 AM