![]() Especially since there is an easy way to resolve the issue by installing the 32-bit ACE driver. Download SSMS 18.6 and read on for some highlights from the SSMS Release Notes. Today we’re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Of course, you could also just uninstall Office 圆4 and install Office x86 - but that would not be my recommendation. The release of SQL Server Management Studio (SSMS) 18.6 is now available for download. Installing SSDT does not install the Office (ACE) driver either - and since SSDT is also a 32-bit application it also will require the 32-bit version of the ACE driver, and as stated above - Office 圆4 installs the 64-bit version. Depending on the version of the driver you are attempting to install - that will be either the /quiet or /passive qualifier. However, you can install the 32-bit version side-by-side by installing it using the command line with the appropriate qualifier. Option 1 is a bit of overkill for a client machine - and option 2 will fail if the 64-bit driver is already installed. Install the 32-bit version of the ACE drivers. ![]() ![]() Install SQL Server (database engine) which includes the 64-bit version of the import/export tool.However, many are now installing the 64-bit version of Office and that doesn't provide the correct driver. SQL Server Management Studio is a 32-bit application - and therefore requires the 32-bit version of the drivers for Office based applications. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |