Ask a new question

Error 3706 after upgrade from Office 2016 to Office 365

Hi,

We have an excel sheet with a number of macros written in VBA.  In Office 2016 it works fine, but when we attempt to run the macros via 365 (Version : 18.2002.1101.0) we are met with this error:


Microsoft Excel

Source: Subroutine Run

Error Number: 3706

Error Desc: Provider cannot be found. It may not be properly installed.

Are there any known issues with upgrades from 2016 to 365 or any fixes you would recommend trying?

Edit: Debugging shows that it is definitely failing on the cnn.Open

...

Public cnn As New ADODB.Connection

...

cnn.ConnectionString = "Provider=SQLNCLI;Data Source=ourDataSource;User Id=OurId;Password=ourpassword;Initial Catalog=ourInitialCatalog;Failover Partner=ourFailoverPartner;"

cnn.Open

So, we had two issues.

First, the provider needed to be changed to SQLNCLI11.

Second, the installations of office 365 were not uniform among all users.  Some received 64bit and some 32 bit.  The spreadsheets work with the 32 bit version but not the 64bit version, hence them working on one workstation but not another.

This was also helpful: h ttps://answers.microsoft.com/en-us/msoffice/forum/all/date-picker-in-excel-not-working/babdc495-25aa-482a-b424-64c53a666a62

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 13, 2025 Views 8,263 Applies to: