• Access To Specific Tables (Read only)

    Sage 300 Version: 23.1.1.72 I am working on a simple interaction between an Excel spreadsheet that extracts data from specific tables within the Sage 300 database. With my "admin" credentials it works but with a specific user's credentials it fails…
  • Sage 300 2022 (PU1) Workstation clients - Random Database connection errors and terrible performance

    We have Sage 2022.1 on our server which is performing perfectly (on the server or through RDP with our VPN firewall). We've installed the Sage Workstation (WSSETUP), ran the Database Setup which created the ODBC and the test connection is fine. Hours…
  • Sage 2022 Update 3 and Sage 2023 require a Server Certificate in place for SQL

    Hi, Does anyone have more specifics in this topic regarding Sage 2022.3 installation and/or setting up? What do we need to do? Buy and install certificate? Just setting ODBC differently? Thank you very much
  • Any information on Sage SQL Server Certificate

    According to the Sage KB116170 information "In a new implementation like 2023 or in an upgrade where a new DSN using the ODBC Driver 18 for SQL Server to connect, your will require a Server Certificate in place for SQL to connect to the SQL database properly…
  • sage 300 2018 workstation : can not access to the database

    I have installed the sage 300 2018 workstation in window 10 64-bit and get the error message said that cannot access the database. And then checking the ODBC 32-bit find that the SQL server has error " SQL server network interfaces: Error Locating Server…
  • Requesting Assistance with a macro Using Range button for searching through SQL Server database

    Good Morning, I am new to VBA and having an issue with a macro which a form. I have added a range button that will accept Two(2) values entered by a user in a and then access data from the database then add it to a Filter List. Currently working on…
  • Only Sage 300 cannot connect to database

    A customer runs Sage 300 v 2012 on SQL. Starting this morning, they have been getting the dreaded 49153 error, intermittently. Happens on all workstations (3). But other applications that use SQL (Accellos, for instance) are running with no problem. …
  • unable to connect to the database error=99

    Dears I Installed SQL 2012 64bit SP1 on the default path and I Installed Sage ERP 300 on the C:\ now when I connect the data base created in the Sql with the sage database via Database Setup the Error appear as follow: unable to connect to the…
  • Work station error ( Cannot access database (error=49153). See help for more information.)

    Hi all, I am using SQL 2014 and ERP 2014. We have two Commercial office building, data center maintaining one location, with help of VLAN we route the network to other Building. I have install workstation in Primary location its working fine, same workstation…
  • Error "unable to connect to the database (error=98)"

    Googled my fingers off trying to resolve this. Looking for any help. Installing Sage 300 ERP 2012 and Pervasive PSQL v11.2 on a local computer. (no server is being used for Sage or data) Running on Windows 7. Pervasive database setup goes ok. (32bit…