Before investigating any DataShare Connect error validate that the SME can access the data through their Accounting Package.
This is the best way to double check the SME is using the correct credentials and has the correct access permissions for the data they are trying to upload.
If the user is unable to access the data using the credentials in their possession then it follows that DataShare connect will be unable to access the data using the same credentials.
For DataShare Connect to access Sage 300 (AccPac) data you will need to know;
- The Sage 300 (AccPac) installation has a valid licence.
- Your SQL Server Username.
- Your SQL Server Password.
- You know the Company from which you wish to upload data.
DataShare Connect will try to connect to the the SQL Server where your Sage 300 (AccPac) companies reside using Windows Authentication if Username and Password credentials are not provided (i.e. The Username and password fields are left blank on the configuration screen)
Supported Versions of Sage 300 (AccPac).
DataShare Connect supports versions of Sage 300 AccPac which are supported by the vendor. However there are versions which are supported by DataShare Connect that the vendor no longer provides support for. To check if your Sage 300 AccPac version is compatible click here.
If Sage 300 (AccPac) is not detected or the user running the upload has no permissions to access Sage 300 (AccPac) DataShare Connect will report "Accounting Package Not Found".
The exact error will be reported in the log file in the %appdata%\validis\logs folder.
This is the file that will be used by support to investigate and fix your issue. Visit this page for more information.
If DataShare Connect does not detect Sage 300 (AccPac) correctly.
If DataShare Connect does not detect Sage 300 (AccPac) correctly check;
- Check that the Sage 300 (AccPac) accounting package can be launched and has an active license.
- Ensure Sage 300 (AccPac) is not installed in Program Files or Program Files(x86). DataShare Connect will not support any installations of Sage 300 (AccPac) that are installed in these locations.
- One way to overcome this is to launch DataShare Connect as an administrator, which is awkward to achieve as DataShare Connect is a clickonce application and does not support elevated rights by default and the current user may not be able to invoke elevated rights.
- Ensure Sage 300 (AccPac) has registered its components as COM components. If you are not sure about this, launch the “RegAcc.exe” application located in the “Runtime” folder within the installation directory of Sage 300 (AccPac). For example, if Sage 300 (AccPac) is installed in the C:\ drive in a folder named “ERPS”, the path to the “RegAcc.exe” will look like this "C:\ERPS\Sage 300 ERP\Runtime\RegAcc.exe".
If DataShare Connect does not accept the credentials supplied.
If DataShare Connect does not accept the username and password you are entering;
- Try using empty credentials (both username and password), to force DataShare Connect to use Windows Authentication.
- Remember that the credentials you need to supply are not those used in the accounting package application. They are the credentials used to log in into the SQL Server Instance.