Websites hosted in Plesk and rely on ODBC driver are showing error: [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

Symptoms

• Websites that rely on ODBC driver are showing the following error message in a web-browser:

  PLESK_INFO: [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed

• The following entries appear in Windows Event Viewer (Windows Logs > Application):

  PLESK_INFO: The description for Event ID 1 from source msodbcsql17 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

Cause

Installation of the component “Microsoft ODBC Driver 17 for SQL Server” is corrupted.

Resolution

1. Connect to the Plesk server via RDP.

2. Open the folder C:ParallelsInstallerparallelsMSODBCSQL-WINthirdparty-windows.

3. Run msodbcsql_17.3.1.1_x64.msi (the version of the filename may vary).

4. In the installation wizard, click Next.

   

5. Select Repair and click Next.

   

6. Click Install.

   

7. Check the websites again.