Sage Error 01000

The Sage error code 01000 is one of the version incompatible errors which usually happens on the screen when the driver failed to support the ODBC version of the requested application. To fix this you need to check the version of the ODBC Driver Manager. The below article is compiled up the troubleshooting fix to resolve the Sage error 01000.

User Navigation

Why Sage error message 01000?

This Sage error [01000][Microsoft ODBC Driver Manager] triggers when the driver is unable to support the ODBC version. It often happens when you install a 32-bit driver for the 64-bit version. Therefore when the Excel integrated reporting is not compatible with MS Excel 2016 64-bit then there will appear a Sage error code 01000. This error may happen because of various other factors. Some of the other causes of the Sage error code 01000 are below:

The driver failed to return
Disabled Windows Event log service
Firewall blocking Microsoft ODBC Driver Manager
Corrupted SAJ Folder
Damaged downloads issue
Data corruption
.Net Framework error
Anti-virus blocking mysqld.exe, or the Driver manager or sent it to the quarantine
SAJ folder with a read-only attribute

How to Resolve Sage Error 01000?

Total Time: 30 minutes

If the issue is because of the incomplete downloads

🔹 Reinstall the Program
🔹 Firstly uninstall the corrupted application then re-install the Sage 50 driver manager with the below steps:
🔹 Open the Command Prompt
🔹 Choose Run as administrator
🔹 Enter sc delete “ServiceName”
🔹 Open Show processes on Task manager to view the deleted services
🔹 End the process named simply.systemTraylcon
🔹 Perform reinstall process

Restart the ODBC Driver Manager

🔹 Initially choose Control Panel window
🔹 Click Administrative Tools and then hit the Services tab
🔹 Now locate ODBC Driver Manager
🔹 Choose “Stop” and then right-click on the same
🔹 Next hit the Start tab
🔹 Make sure you have administrative rights to access the above procedure

Restart Event Log Service

🔹 Choose Control Panel
🔹 Click Administrative Tools
🔹 Hit Services button
🔹 Choose service list and then click Windows Event Log
🔹 Now double-click on it to launch the Properties Page
🔹 Switch the startup type to Automatic if service is disabled
🔹 Choose Apply button and then click the Start tab
🔹 If the service is automatic or available then choose the Start tab to start the service
🔹 Hit OK
🔹 If the service starts then launch the Sage 50
🔹 If services failed to start then there appears an error so choose Log on option
🔹 Click Add the local administrator
🔹 Start the service status
🔹 Open Command Prompt with administrator rights
🔹 Enter cd C:\Windows\System32\LogFiles\WMI
🔹 Fill cd C:\Windows\System32\LogFiles\WMI
🔹 Enter rename RtBackup RtBackup2
🔹 If the error appears then click on the Start tab
🔹 Choose Command Prompt and then give right-click on it
🔹 Select Run as Administrator
🔹 Type the below commands
🔹 takeown /f C:\windows\system32\logfiles\wmi\rtbackup
cacls C:\windows\system32\logfiles\wmi\rtbackup /G administrators:F
🔹 Close Command Prompt
🔹 Reboot the system

Verify the compatibility issue

Here are the below steps:

🔹 Restart the system and then log on as an administrator
🔹 Now right-click on the below relevant download link:
🔹 Sage 50 Accounts v28 64-bit ODBC installer
🔹 Sage 50 Accounts v27 64-bit ODBC installer
🔹 Now browse to download location then hit the save button
🔹 Choose “Save link as/Save target as “
🔹 Select the downloaded file
🔹 Choose the Sage50cloud Accounts v28 only
🔹 Now right-click on the Sage50Accountsv28_ODBC64Bit.zip file
🔹 Hit extract all
🔹 Choose Extract button
🔹 Now double-click on 64 Bit file
🔹 It will appear Open file-security warning page displays to start the installation
🔹 Hit Run button
🔹 Choose the checkbox named I accept the terms in the License Agreement
🔹 Select Install
🔹 Hit Finish tab
🔹 Restart the system

Closure:

Here the article completes! Hopefully, you are now confident to implement the troubleshooting steps to resolve the Sage Error 01000. However, if you face any hassle regarding the above steps or any question running in your mind then get connected to the Sage professional team. The experts are there to resolve all your concerns and doubts. Use a Sage 50 live chat, phone number 1800 964 3096, and email address [email protected] to fix the issue.

FAQs🙏:

How would I check the read-only attribute in the SAJ folder?

🔸 Initially close the Sage 50 Canadian Edition
search the company file location and then give a right-click on it with an extension SAJ
🔸 Choose Properties button
🔸 Check the checkmark on the box named read-only then clear it
🔸 Choose OK

How Can I Open the Existing Company File?

🔸 Choose the “Select an existing company” tab
🔸 Search to the company file in Windows Explorer

How would I check the existence of the mysqld.exe and mysqld-nt.exe?

🔸 Check the file named mysqld-nt.exe file and mysqld.exe file in: C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.0.38\mysql

How would I fix the error caused by Antivirus?

🔸 Open the Antivirus and open the Options
🔸 Choose Virus Vault
🔸 Click on the processes related to the windows path and then start fixing the issue
🔸 AVG require to be active to do restoration
🔸 Remove the file with the below steps:
🔸 Fix the Sage 50
🔸 Disable the antivirus temporarily
🔸 Choose Control Panel
🔸 Click Program & Features
🔸 Click Change button
🔸 Choose the option named Update/Reinstall