Error: Sage Error Connecting to Database
Technical errors can often be categorized as run-time errors, logistic errors or synchronized errors. Sage Error Connecting to Database is a run-time error. While you are working on it, you are unable to open any file and you will receive the following error message:Error: “Cannot open company, there is an Sage error connecting to database”
When you are trying to open any data file, you may encounter this error. The various reasons which are responsible for this error are problems which occur in server computer or ODBC issues, etc.
Resolution:
Here are some solutions which are recommended by sage experts to resolve this Sage 50 Error:
Solution I: The data files resides in C:\Program Files\ (or C:\Program Files (x86)\)
- Change the location of .SAJ folder and .SAI file outside of C:\Program Files\ (or C:\Program Files (x86)\).
- Select the SAJ folder and right click on it.
- Select “Properties” option.
- You will have to un-tick the “Hidden” and “Read-only” checkboxes.
- Go to “Security Tab”.
- Make sure that all Groups or Username which are working on this server or workstation are listed and have Full Control access rights.
- Click on OK option.
- Click on SAJ folder and open it.
- Now you will have to delete the file process .pid
- Check that you have installed ODBC on your system.
- To verify that you will have to look for it in Programs and Features or Add Remove Programs.
- If your system is missing that, then Install ODBC by browsing to C drive (C:\Sage\Sage 50 Accounting <version>\BIN\MySQLODBC\)
- You will have to run mysql-connector-odbc-commercial-<version>.exe file in your system.
Source: https://goo.gl/uAh3mv
0 comments:
Post a Comment