Sage 100

 View Only

  • 1.  ODBC Issue Using PR_Employee

    Posted 05-03-2019 16:17
    Edited by Doug Higgs 05-04-2019 09:16
    The end users just changed / upgraded servers and migrated from Sage 100 v2015 to v2018 including the new payroll.  They are using odbc for Time Clock Plus integration.  When we change the connection from PR1_EmployeeMaster to PR_Employee we can't view the employee first name or employee last name.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 2.  RE: ODBC Issue Using PR_Employee

    Posted 05-03-2019 16:24
    "Encrypted" fields are not available through ODBC.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: ODBC Issue Using PR_Employee

    Posted 05-03-2019 18:19
    Edited by Bob Pfahnl 05-03-2019 18:23
    PII fields


    ------------------------------
    Bob Pfahnl
    DSD Business Systems
    ------------------------------

    Original Message


  • 4.  RE: ODBC Issue Using PR_Employee

    Posted 05-04-2019 09:17
    Thanks @Bob Pfahnl and @Kevin Moyes !​​

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 5.  RE: ODBC Issue Using PR_Employee

    Posted 05-05-2019 00:17
    Edited by Dan Burleson 05-05-2019 00:43
    @Doug Higgs I have a work around to make encrypted fields available to external programs via ODBC (other than premium). Email me if you are interested.​

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Original Message


Related Content