Skip to content
  • There are no suggestions because the search field is empty.

Upgrade Microsoft OLE DB Driver for SQL Server from version 18.6.5.0 to version 18.7 

In certain situations, Acctivate users may need to upgrade the Microsoft OLD DB Driver on each workstation running Acctivate to the current driver version.  Users can uninstall the installed version, download and reinstall the newest version, then continue using Acctivate.  

This process needs to be completed on each workstation where Acctivate is installed.  This process should take only a few minutes to complete.

 
Step-by-Step Instructions
 
Step 1: Uninstall Microsoft OLE DB Driver for SQL Server 18.6.5.0
  1. Close Acctivate and Related Applications:
    • Ensure Acctivate and any SQL Server-related applications are closed to avoid conflicts during uninstallation.
  2. Access Programs and Features:
    • On your Windows computer, press Windows + R, type appwiz.cpl, and press Enter to open the "Programs and Features" window.
  3. Locate the Driver:
    • Scroll through the list of installed programs and find Microsoft OLE DB Driver for SQL Server. Check the version number to confirm it is 18.6.5.0.
    • Select Microsoft OLE DB Driver for SQL Server and click Uninstall.
    • Follow the on-screen prompts to complete the uninstallation process.
    • If prompted, restart your computer to ensure all components are removed.Uninstall the Driver:
Step 2: Download and Install Microsoft OLE DB Driver for SQL Server 18.7 or Newer
  1. Download the Latest Driver:
    • Run the downloaded msoledbsql.msi file.
    • Follow the installation wizard’s prompts to complete the installation.
      Install the Driver:
Step 3: Test Acctivate Functionality
  1. Launch Acctivate and verify that it connects to your SQL Server database without errors.
Troubleshooting
  • Error 1603 During Installation:
    • Ensure you have installed both 32-bit and 64-bit versions of the Microsoft Visual C++ Redistributable.
    • Run the installer as an administrator (right-click msoledbsql.msi > Run as Administrator).
    • Check the installation log for details by running the installer with verbose logging: msiexec /i msoledbsql.msi /L*v log.txt.
  • Driver Not Found After Installation:
    • Ensure the correct driver version is installed and that Acctivate is configured to use the updated driver in its connection settings.
    • Uninstall and reinstall the driver, ensuring no older versions remain.
  • Compatibility Issues with Acctivate:
    • Verify that your Acctivate version is compatible with the new driver. Contact the Acctivate Support Team if you encounter issues.
Additional Notes
  • If you are using Microsoft SQL Server 2022 or considering upgrading to Microsoft OLE DB Driver 19.x, note that version 19.x uses a different provider name (MSOLEDBSQL19). Update your connection strings accordingly. 
  • The Microsoft OLE DB Driver 19.x is not compatible with Microsoft SQL Server versions 2014 or older.  
  • Always back up your Acctivate database and configuration files before making changes to drivers or software.
  • For the latest driver versions and release notes, refer to Microsoft’s official documentation: Microsoft OLE DB Driver for SQL Server.