Solution Properties
Solution ID:
220924150010086
Last Modified Date:
Fri Jan 27 20:10:45 UTC 2023
Taxonomy Path:
Category//Performance//Connectivity//Product
Author:
sageadmin
Error: "Database engine timed out" when opening files to upgrade
Description
Cause
  • A MySQL Connector/ODBC is not installed, has been replaced or is not compatible
Resolution
[BCB:5:Third-party support:ECB]



Notes:

  • MySQL Connector/ODBC 3.51 is needed to open or convert company files last opened in Sage 50 2013 or earlier.
  • MySQL Connector/ODBC 5.2(a) is needed to open or convert company files last opened in Sage 50 2022 or earlier.
  • MySQL Connector/ODBC 8.0 is needed to open company files last opened in Sage 50 2023 or newer.

Method 1: MySQL Connector 5.2(a)

  1. Go to the Control Panel.
  2. Open Programs and Features (Windows 7/Vista).
  3. Locate and highlight MySQL Connector/ODBC 5.2.
  4. Select uninstall from the menu bar. Or right-click MySQL Connector/ODBC 5.2 and choose Uninstall to remove it.
  5. After uninstalling, open Windows Explorer to find the Sage 50 installation files
    • The default location is in the root of local C drive: C:\\Sage\
  6. Go to C:\Sage\Sage 50 Accounting Installer Files - CDN Release 201X\BIN\MySQLODBC\.
  7. If you do not have this Sage folder available on your computer: Please see the Attachments section of this article to download mysql-connector-odbc-5.2.4-ansi-win32.zip.
  8. Unzip the file into a temporary folder.
  9. Double click on the file mysql-connector-odbc-commercial-5.2.4-ansi-win32.msi to install MySQL Connector 5.2(a).
  10. Reboot your computer after the ODBC driver installation.
  11. After installing MySQL5.2(a), and if you still get the same error, then follow Method 3.

Method 2: MySQL Connector 5.2(a) is not installed

  1. Go to C:\Sage\Sage 50 Accounting Installer Files - CDN Release 201X\BIN\MySQLODBC\.
    • If you do not have the Sage folder available, see the Attachments section of this article to download mysql-connector-odbc-5.2.4-ansi-win32.zip
  2. Unzip the file into a temporary folder.
  3. Double click on the file mysql-connector-odbc-commercial-5.2.4-ansi-win32.msi to install MySQL Connector 5.2(a).
  4. Reboot your computer after the ODBC driver installation.
  5. After installing MySQL5.2(a), and if you still get the same error, follow Method 3.

Method 3: Both MySQL ODBC Connector 3.51 (version 3.51.28) and 5.2(a) (version 5.2.4) are installed

  1. Click on Control Panel.
  2. Open Programs and Features (Windows 7/Vista).
  3. Locate and highlight MySQL Connector/ODBC 3.51 (Version 3.51.28).
  4. Select uninstall from the menu bar or right-click MySQL Connector/ODBC 3.51 and choose Uninstall to remove it.
  5. After uninstalling, open Windows Explorer to find the Sage installation files
    • The default location is in the root of local C drive: C:\\Sage\
  6. Navigate to C:\\Sage\Sage Simply Accounting 201X Installer Files – CDN\BIN\MySQLODBC\.
  7. If you do not have this Sage folder available on your computer, see the Attachments section of this article to download an ODBC driver for version 3.51.19.
  8. Unzip the file into a temporary folder.
  9. Run the mysql-connector-odbc-commercial-3.51.19-win32.msi.
  10. Reboot your computer after the ODBC driver installation.
    • Installing Sage 50 201X installs MySQL Connector/ODBC 5.2(a) and you should not remove this

Method 4: MySQL Connector/ODBC 8.0 is missing

Note:Only Sage 50 2023 and newer use the 8.0 ODBC connector

  1. Uninstall the latest version of Sage 50 you have installed, all the Mysql ODBC connectors, and all versions of Microsoft Visual C++.
    • Note: This could cause other software to stop working.
  2. Reinstall Sage 50.
  3. If the 8.0 connector is still missing after the reinstall, install from the links below
  4. If the 8.0 connector installer gives an error message, either log in as a different existing windows user or create a new windows user and reinstall Sage 50 while logged in with the new user.

Method 5: Deleting Database Connection Manager completely

  1. Uninstall Sage 50.
  2. Stop the Connection Manager service.
  3. Check the name of the service, open Control Panel, Administrative Service, Services. Scroll down to Sage 50 Database Connection Manager.
  4. Double-click Sage 50 Database Connection Manager. Verify the service name.
  5. Run cmd as "Run as administrator".
  6. On the command prompt, enter C:\Windows\system32> sc delete "Simply Accounting Database Connection Manager".
    • The command prompt should show - [SC] DeleteService SUCCESS
  7. On the Task Manager, under Processes tab, select Simply.SystemTrayIcon.exe*32 and End Process.
  8. Go to C:\Program Files (x86)\ and rename the winsim folder to WinsimOld
  9. Reinstall Sage 50.

Method 6: None of the above methods worked

  1. If the above methods did not work, use the System Restore feature to restore your computer to an earlier point, before the latest version of Sage 50 was installed.
    • See the Additional Information below for more information
  2. Install Sage 50 again.

348_20230425110158_260-1001733 - mysql-connector-odbc3.51.19-win32.msi.zip
274_20230425110158_mysql-connector-odbc-5.2.4-ansi-win32.zip

Steps to duplicate
Related Solutions