Sage 100

 View Only

  • 1.  Scanco Mobile Sales

    Posted 10-06-2020 15:39
    Does anyone have clients successfully using Scanco Mobile Sales?  If so, what version/PU of Sage are they running?

    The client had it successfully working against a test Sage company a few months ago and now that they are ready to go live it no longer works.  Scanco's ConnectIt service is continuously crashing.  It's been proven that the Scanco ODBC driver can successfully pull Sage data.  We and Scanco support at multiple levels have been involved and can't figure it out.  Scanco indicated to the client that they are about ready to give up on solving it!  

    The client is running v2018 Advanced and without Scanco having a clue as to why it's failing I'm hesitant to suggest upgrading to v2020.

    ------------------------------
    Shari Eckersley
    ICS Support
    ------------------------------


  • 2.  RE: Scanco Mobile Sales

    Posted 10-06-2020 23:36
    Edited by Alnoor Cassim 10-07-2020 00:48
    I seem to remember few years back somebody here mentioned stability problems with the ConnectIt service using the normal Sage 32-bit ODBC driver and in the end Scanco developed a 64-bit version of the service connecting with the Sage 64-bit ODBC driver without any issues. Maybe they could try 64-bit version of ConnectIt service if not already being used.

    Also any chance their ODBC connection is using the Client Server ODBC driver service? I imagine it wouldn't since ConnectIt service is already running on the Sage server (right?). But in case CS ODBC is in play, there is a property in the ODBC connection string called Compression that causes instability. IOW there are 3 ODBC settings for CS ODBC but only 2 should be used:
    1. RemotePVKIOHost (the server name or IP)
    2. RemotePVKIOPort (usually 20222)
    3. Compression (usually omitted which is same as = 0 to mean OFF but if ON you would see it as = 1 which you don't want)
    Hope that helps.

    ------------------------------
    Alnoor Cassim

    Email: alnoor@asifocus.com
    Ph: 949-689-9887
    Orange County, CA
    ------------------------------



  • 3.  RE: Scanco Mobile Sales

    Posted 10-07-2020 13:10
    2018 PU4, 2019 PU2 I have successfully running at three clients. I had 2019 running on my demo machine, but recently updated to 2020 and have not reinstalled. Does the client have any "active scanning" AV or security software or appliances that may intermittently ​be causing issues with the program or port?

    ------------------------------
    Jim Fuller
    Velosio LLC
    ------------------------------



Related Content