Forum Discussion

Jessbase's avatar
Jessbase
Copper Contributor
Jun 25, 2020

ODBC not working after Office365 Proplus Upgrade

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.

office 365

1 Reply

  • ChristianBergstrom's avatar
    ChristianBergstrom
    Silver Contributor
    Jun 26, 2020

    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-365-apps

     

    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.

Resources