• ODBC Connections and Intergrations with Business Works

    Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …
  • Where to download Pervasive 10 SP3 Linux ODBC drivers?

    Does anyone have or know where to find Linux ODBC drivers for the Pervasive 10 SP3 database used by BusinessWorks?
  • ODBC customer ID

    I am making an ODBC connection from UPS WorldShip to BusinessWorks 2013. I am able to map most of the WorldShip values to BusinessWorks values in the ARInvoice table. I want to link the BW customer ID or number to UPS. 1. Does one of the values in…
  • ODBC Tables and Reporting

    I use Microsoft Access to automatically generate pick tickets from BW based on available inventory. My problem is I cannot get the line items to "sort" correctly to match how they print on BW Invoices and Sales Orders. How does BW sort order the line…