Page 1 of 1

ProcessMaker SQL Server Database Configuration

Posted: Thu Oct 23, 2014 8:50 am
by nadiois
I have installed ProcessMaker 2.5.2 with MySQL 5.5.40 and Apache 2.4.10 with PHP 5.5.17. The SO is Windows 2012 64 bit.
Now I'd like to configure database connection for SQL Server 2012; I have downloaded in PHP ext folder the driver (php_sqlsrv_55_ts.dll, php_pdo_sqlsrv_55_ts.dll) in my php.ini I added this line:
extension=php_sqlsrv_55_ts.dll
extension=php_pdo_sqlsrv_55_ts.dll

When I try to add a new db source in the Engine drop down there isn't the SQL Server choise.

Could someone help me, please?

Re: ProcessMaker SQL Server Database Configuration

Posted: Thu Oct 23, 2014 3:38 pm
by marcoramirez
Hi nadiois,

did you install the instant client?. http://www.oracle.com/technetwork/topic ... 85727.html

Re: ProcessMaker SQL Server Database Configuration

Posted: Fri Oct 24, 2014 5:17 am
by nadiois
Hi Marco,
thank you for reply. I think that the instant client is for Oracle database, not for MS SQL Server.

Now I solved the problem following the instructions from http://wiki.processmaker.com/index.php/ ... SQL_Server, section "Setup a UTF-8 Connection to a MSSQL database server". Now my php.ini contains:
extension=php_dblib.dll
extension=php_sqlsrv_55_ts.dll
extension=php_pdo_sqlsrv_55_ts.dll

When I try to create a new db source, I have an error in step 2 "Checking port 1433" and the "Create" button is disabled, so I can't add the new db source:
db_con_pm.png
db_con_pm.png (16.49 KiB) Viewed 3890 times