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