Notice
DataPlus 4.0 Error
The following error has occurred: Cannot initialize the data source object of OLE DB provider "MSDASQL: for linked server "S50-Universl".

Resolution

1. The user name and or password was entered in incorrect in "MySQL Connection/ODBC Data Source Configuration.

Configure Data Source (ODBC)
2. Click on System DSN tab

Configure Data Source (ODBC)
3. Click on Source Name S^_Universl
4. Click on Configure

Configure Data Source (ODBC)
5. Modify User: sagecompanycode
6. Modify Password: sagepassword
7. Click on Test
8. 
9. Click on OK

Configure Data Source (ODBC)
10. Click on OK

Notice
Notice
Unable to update database. Reason given: Cannot initialize the data source object of OLE DB provider 'MSDASQL.1' for linked server "Sage50". ODE DB provider "MSDASQL.1: for linked server "Sage50" returned message "[MySQL][ODBC 5.1 Driver]Unknown MySQL server host "SERVERNAME' (2)".

Task
Installation of Sage Database

Resolution

11. The "Sage 50 Server" name is incorrect
12. Click on OK
13. Click on Previous
14. Correct "Sage 50 Server"

Notice
Notice
Unable to update database. Reason given: Cannot initialize the data source object of OLE DB provider 'MSDASQL.1' for linked server "Sage50". ODE DB provider "MSDASQL.1: for linked server "Sage50" returned message "[MySQL][ODBC 5.1 Driver]Unknown MySQL server host "SERVERNAME' (2)".

Task
Installation of Sage Database

Resolution

15. The "Sage 50 Server" name is incorrect
16. Click on OK
17. Click on Previous
18. Correct "Sage 50 Server"

Notice
Notice
Unable to update database. Reason given: Cannot initialize the data source object of OLE DB provider "MSDASQL.1" for linked server "Sage50:.
OLE DB provider "MSDASQL.1" fo rlinked server "Sage50: returned message "[MYSQL][ODBC 5.1 Driver]Access denied for user 'sysadmin' @ 'SERVERNAME\SQLINSTANCE' (using password: YES)"

Task
Installation of Sage Database

Resolution(s)

19. ODBC username or password is incorrect
20. ODBC password has more than 7 characters
21. Click on OK
22. Click on Previous
23. Correct username and/or password in Sage and ODBC System DSN

Notice
Act! Notice
Sage connection failed. Unable to open the company file.

Resolution

24. 1. User name or password is incorrect in
25. 2. HoganData Sage50CA Bridge

Warning
DataPlus 4.0 Warning
No DataPlus menus were found. The DataPlus Tab will be disabled.

NOTE: If this is your first install, you bust set default view permissions and re-load DataPlus.

Resolution

26. Server Installation KB Line 163

Error
DataPlus 4.0 Error
The following error has occured: Product is not activated and trial has expired. All DataPlus features will be disabled. Please run activation and re-enable DataPlus.

Resolution

27. Server Installation KB Line 187
28. Client Installation KB Line 27

Notice
Act! Notice
Sage connection failed. The user name and password are incorrect. Please enter a valid user name and password.

Resolution

29. In Act goto Tools/Sage50/Configure Sage 50 Push
    • Connection Tab
    • Company Settings
    • Correct User
    • Correct Password

Notice
Act! Error
The following error has occurred: Failed pushing Customer. Err

Resolution

30. In Act goto Tools/Sage50/Configure Sage 50 Push
    • Test Connection
    • If it fails, restart the service "Hogan Data Sage50 Bridge"

Notice
Act! Notice
Sage connection failed. Unable to connect to Sage50 database. The company file cannot be opened because it's version (##.#.#.#) is not compatible with the application (##.#.#.#).

Resolution

31. Your Sage 50 CA SDK version is not compatible with the DataPlus 4.0 SDK version
    • Update you SDK version
    • Click here for SDK update and instruction

Notice
Act! Notice
Sage connection failed. Unable to connect to Sage50 database. Other users are currently working with this company. You may open the company in multi-user mode or wait for the other users to stop using the company and try again. Cannot open company file '{0}'. the file is currently used by another application.

Resolution

32. In Sage 50 CA Switch to Single-user Mode

Notice
Act! Notice
Sage connection failed. Error communicating with Sage50. There was no endpoint listening at http://yourservername:8000/Sage50Bridge/proxy.svc that could accept the message. This is often caused by an incorrect address or SOAP action. Dee InnerException, if present, for more details.

Resolution

32. Ensure that the "Hogan Data Sage50CA Bridge" windows service is started.

Error
Act! Error
The following error has occurred: Failed pushing Customer. Unable to parse connection information. Reason Given: Connection Info was not properly populated.

Resolution

33. In Act goto Tools/Sage50/Configure Sage 50 Push
    • Connection Tab
    • Company Settings
    • Correct User
    • Correct Password

Act! Error
Push to Sage 50 Error
The following error has occurred: eCustomerID is read-only field. It cannot be modified.

Resolution

34. By default the eCustomerID is read-only for all Act users except Act Administrators.
35. You must change field permissions to allow other users to perform the push.

Act! Error
Push to Sage 50 Error
The following error has occurred: Failed pushing Customer. Failed creating entity. You have entered a name that has been assigned to another Customer. You cannot have two Customers with the same name.

Resolution

36. This is a rule within Sage 50.

Sage 50 error message when trying to create company with duplicate name.

Act! Error
Push to Sage 50 Error
The following error has occurred: Failed pushing Customer. Unable to connect to Sage50 database. Unable to open the company file.

Resolution

37. Update your SDK version for DataPlus
38. KB