• I can't establish a connection via ODBC

    Hello Colleagues, I have a problem connecting to Sage 50 from ODBC, when I try to connect to the database from excel or another program it does not validate my credentials. I have done all the processes in the documentation, I enabled the permissions…
  • ODBC (64 bit) connection to new 50c 2020.0 with Actian Zen v13 database

    FormerMember
    FormerMember
    After Upgrade to 50c 2020.0 with Actian Zen v13 database where can I find an ODBC (64bit) Driver to connect directly to the database? I can connect with the ODBC (32 bit) but it will not function with Microsoft Access 64 bit.
  • Pulling data from Sage 50 Database with ODBC at a specific time in the past to produce a trial balance

    FormerMember
    FormerMember
    The current situation : We are using ODBC to pull data from the Sage 50 database to Excel. For example, if we pull the table taccount from the database we get the table with the GL accounts list and the amount at the present time. It produces a trial…
  • Connecting to Audit Trail .DAT using SQL?

    I have been using SQL Server to connect to my .DATs without issue and today tried connecting to the AUDITTR.DAT but am getting the message that the object does does not exist. I am certain this isn't a typo or something simple like that, so I'm wondering…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • Pervasive PSQL v11 - Number of users connected with Sage50 and third party software

    How many users have pervasive with Sage50 ? I noticed that pervasive shows a message that reached a maximum number of users when use third party software. I have Sage50 5 users and others third party software connected via SDK and ODBC. f