Follow the instructions on the wiki:
https://wiki.processmaker.com/3.3/Datab ... ions/MSSQL
The instructions aren't complete if you are using ProcessMaker installed in Windows.
library only works if you are using PHP 5.6. Please go to Admin > System Information
in ProcessMaker to verify which version of PHP you are using.
If you are using PM 3.3.0 or later with PHP 7.0 or later in Windows, then you need to follow these instructions to install
the SQLSRV and PDO_SQLSRV drivers:
https://docs.microsoft.com/en-us/sql/co ... erver-2017
Here is the page to download the files:
https://www.microsoft.com/en-us/downloa ... x?id=57916
After you have installed the PHP files for MSSQL, then you can create a Database Connection that connects to your installation of MSSQL. Then, you can use the ID of the Database Connection when calling the executeQuery()
function in a trigger.
Amos B. Batto ♦ ProcessMaker Forum Manager since 2009