ODBC not working after Office365 Proplus Upgrade

Copper Contributor

Recently we upgraded our MS Office to Office365 Proplus. We have macros in excel that connecting to SQL server. After the upgrade, our macros is not working anymore and it throws an error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

1 Reply

@Jessbase Hey, as Microsoft 365 Apps for enterprise (Office 365 ProPlus) update at a consistent interval (depending on update channel) it's necessary to set up pilot users and/or perhaps use the Readiness Toolkit.

 

Use the Readiness Toolkit to assess application compatibility for Microsoft 365 Apps

https://docs.microsoft.com/en-us/deployoffice/readiness-toolkit-application-compatibility-microsoft-...

 

Overview of update channels for Microsoft 365 Apps

https://docs.microsoft.com/en-us/deployoffice/overview-update-channels

 

As for the problem you have right now I recommend the official Microsoft support.