Browse By Tags

  • Default ODBC Driver Incompatible with Server OS Version

    We have a new Windows Server 2019 and SQL Server 2019 for our Sage 500 upgrade to version 2021. We use Sage via RDP. The Client is not installed on user PCs. They RDP to the server which is configured to launch a Sage session for the user. Sage is working…
  • ODBC connection after upgrade to 22.2

    I have a bunch of excel files that ready from different AP, AR, JC etc tables using a User DSN with the Timberline Data driver. Prior to upgrading today, they all worked. Since the upgrade, I'm getting an error that the "required credential settings are…
  • 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…
  • 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... Where…