• Accessing Sage 300 ODBC via powershell [Sage][SQLEngine] (31830) Username and password is required.

    I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. 

    I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. 

    What am I missing?

    Exception calling "Open" with…
  • Sage 300 CRE JDBC connection via Pervasive

    I am trying to connect to Sage 300 CRE via JDBC.

    I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables.

    i am looking for guide to read Sage specific tables using this pervasive…

  • Are there any plans whatsoever for 64-bit ODBC drivers?

    Many of us are not using SQL replicator as the hardware requirements are up there, server and client, and we have enough data that I believe we would need full SQL vs express.  Especially if your accounting dept wants the data to be live.(which ours does…

  • How do I get information from imported HH2 hours?

    We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database.

    We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time...

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

  • Is it possible to connect to the Pervasive Database from a Linux machine?

    Making queries from excel / crystal reports is easy on a windows computer using the ODBC connections, but is this something that has been done from Linux computers on the network? For instance, if we have an application running on a random computer controlling…

  • Connecting Crystal Reports 2016 to Sage 100 Contractor v20.5

    I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection.  I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit…

  • Accessing Sage 100 Contractor 2016 Database with Microsoft Access 2010

    How can the Sage 100 Contractor 2016 (version or greater) databases be accessed using Microsoft Access 2010?

    I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in Access…

  • Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check

    Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check, while other columns respond as expected


    • 32-bit ODBC driver – installed OK
    • Sage Role/user verified – OK
    • DSN – User DSN and System…
  • ASP.NET MVC to Timberline connection

    I am having trouble connecting to timberline from my asp.net mvc 4 application.


    String connection = "DSN=Timberline Data Source;Uid=<myusername>;Pwd=<mypassword>;";
    OdbcConnection timberlineConnection = new OdbcConnection…

  • Slow ODBC Queries

    Hello All,

    I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions....

    We have a web server that uses PHP to query several database…