Browse By Tags

  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file.   I don't want to archive, I just want to delete.  I have tried ODBC connect…

  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB.

    In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db.

    Class name is: com.pervasive.jdbc.v2.Driver.

    URL is in format…

  • Ts.ctl file in use during backup vs 17.1.8

    Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7):  Common Tasks - Tools - File Tools - Backup

    The "ts.ctl" file is in use when we try to use file tools to backup our data.  The knowledgebase leads you to various…

  • Database Schema for Sage 300 CRE?

    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…