• error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753  12:00:00 AM and 12/31/9999 11:59:59 PM"

    What is this?

    I write reports, and get client databases to work in. This is the…

  • 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…

  • 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…