Sage 100

 View Only

  • 1.  KnowledgeSync KLF

    Posted 01-22-2021 18:26
    Hi all,

    Trying to get the KLF component to connect to a Sage 100 Pvx database.  I keep getting errors when trying to use any of the Event Pack queries - or any connection to the database for that matter.  The link Access db is created.  When I try to connect to the Link Access database using crystal, I get the same error message that I see in KS:

    (-2001)s1000:[Microsoft][ODBC Microsoft Access Driver] Odbc connection to 'sotamas90' failed.

    Any KS experts out there?  I have a case started with KS Support, however am not getting anywhere there yet.

    Since the error is both in KS and crystal and related to the odbc it has to be something there, but I cant quite see it.

    thanks,
    Marc

    ------------------------------
    Marc Cregan
    Technology Integrators
    ------------------------------


  • 2.  RE: KnowledgeSync KLF

    Posted 01-22-2021 18:41
    Which version of KS are you using?



    Sent via the Samsung Galaxy Note10+ 5G, an AT&T 5G smartphone








  • 3.  RE: KnowledgeSync KLF

    Posted 01-22-2021 19:18
    hi Version 9.

    ------------------------------
    Marc Cregan
    Technology Integrators
    ------------------------------

    Original Message


  • 4.  RE: KnowledgeSync KLF

    Posted 01-23-2021 12:50
    Hi Marc
      The connection in KS and in the report should be to the access database created by the KLF, not to SOTAMAS90.    I am assuming you created a silent connection for the KLF to use when you linked Sage to the KLF, otherwise it won't work as it can't log in to populate the access table.  In the knowledgebase you can search silent connection just in case you haven't done this.

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------

    Original Message


  • 5.  RE: KnowledgeSync KLF

    Posted 01-24-2021 14:09
    Be sure to setup a new ODBC Connection to Sage and us it in the KLF. This way you can "save" the Sage user id and password.

    In the KLF, the setup should use this connection and not the SOTAMAS90.


    ____

    In the following example we will be using the following variables

    Company Name – ABC

    LogIn – sherman

    Password – mrpeabody

     

     

    Many times we see the credentials do not stick in the Providex ODBC System DSN for some reason, so you may have to repeat this exercise.  Nothing to be done, simply a conflict with Windows/MS Access and the Providex ODBC Driver.

     

    Create a 32 Bit Providex ODBC System DSN named:

    ABC_PVX ("Company name" with _PVX suffix)

    We generally clone the SOTAMAS90 User DSN and add the LogIn information

    Do not name it SOTAMAS90.

    Do not set it to "Silent Mode"

     

     

    Create a 32 Bit Providex ODBC System DSN.

    "Test Connection."

    Make sure you do not see any Login Prompts.

     

    Stop the KnowledgeSync Windows service.

     

    Delete the MS Access Linked ODBC SYSTEM DSN.

    Delete the MS Access ODBC Linked Database used by the MS Access ODBC SYSTEM DSN..

     

    In the Event Manager

    Highlight the Application using Linked Database.

    "Properties"

     

    Hit the dropdown.

    See if you have multiple Identically named Connections out there.

    If you do, delete them

    If not, delete the Connection associated with MS Access Linked Database.

     

    Open the Event Manager

    Relink.

    Verify that the MS Access Linked Database has been created successfully.

    Recreate the MS Access Linked ODBC SYSTEM DSN using the new Linked Database.

     

    Close the Event Manager

    Open the Event Manager

    Highlight the Application using the Linked Database.

    "Properties"

    New Connection.

    Grab the newly created MS Access ODBC SYSTEM DSN.

     

    Test a Query to make sure the LogIn prompts are gone.
    ___


    Thank you
    Michael

    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    Birmingham, AL
    ------------------------------

    Original Message


  • 6.  RE: KnowledgeSync KLF

    Posted 01-25-2021 07:32
    Any chance you have a 64 bit version of Access but not the 64 bit Sotamas driver installed?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content