Topics > DataPlus Sage Accounting Integration > DataPlus 4.0 Sage 50 CA Accounting > FAQ ID # 80

FAQ ID # 80
Last Update : 2018/06/11
Print this FAQ

Question / Issue
DataPlus 4.0 Sage 50 CA - Messages

Answer / Solution
Table of Contents

PROGRAM: DataPlus for Sage 50 CA - Messages

 


DataPlus Installation
    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)
  1. Click on System DSN tab
    Configure Data Source (ODBC)
  1. Click on Source Name S^_Universl
  2. Click on Configure
    Configure Data Source (ODBC)
  1. Modify User: sagecompanycode
  2. Modify Password: sagepassword
  3. Click on Test
  4. Click on OK
    Configure Data Source (ODBC)
  1. 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

  1. The "Sage 50 Server" name is incorrect
  2. Click on OK
  3. Click on Previous
  4. 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

  1. The "Sage 50 Server" name is incorrect
  2. Click on OK
  3. Click on Previous
  4. 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)

  1. ODBC username or password is incorrect
  2. ODBC password has more than 7 characters
  3. Click on OK
  4. Click on Previous
  5. Correct username and/or password in Sage and ODBC System DSN

 


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

    Resolution

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

 


DataPlus Tab
    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

  1. Server Installation KB Line 163

 


DataPlus Activation
    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

  1. Server Installation KB Line 187
  2. Client Installation KB Line 27

 


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

    Resolution

  1. 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

  1. 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

  1. 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

  1. 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

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

 


DataPlus Push
    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

  1. 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

  1. By default the eCustomerID is read-only for all Act users except Act Administrators.
  2. 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

  1. 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

  1. Update your SDK version for DataPlus
  2. KB

Related FAQs
DataPlus 4.0 Sage 50 CA Accounting - Server Installation
DataPlus 4.0 Sage 50 CA Accounting - Client Installation
DataPlus 4.0 Sage 50 CA Accounting - Act! Database Configuration
DataPlus 4.0 Sage 50 CA Accounting - Push
DataPlus for Sage 50 CA Accounting - SDK
Sage 50 CA English

Direct Link to This FAQ
http://kb.hogandata.com/?f=80

Back to Top