[ashkufaraz]

Hi

Capture.PNG (113.44 KiB) Viewed 33072 times

Warning: Currently, there is NO php_dblib.dll file that works with PHP 5.6.x of 64bits.

Robs generate unofficial modified builds of Microsoft's sqlsrv and pdo_sqlsrv drivers for PHP 5.6 64bit
https://robsphp.blogspot.nl/2012/06/uno ... river.html
https://onedrive.live.com/redir?resid=6 ... 1774%21720(please add this link to wiki)

After download sqlsrv_unofficial_3.0.2.2.zip add \x64\php_sqlsrv_56_ts.dll to \processmaker-3.2.1-0\php\ext\
Then edit \processmaker-3.2.1-0\php\php.ini file and add this line to it extension=php_sqlsrv_56_ts.dll

Then edit processmaker-3.2.1-0\apps\processmaker\htdocs\workflow\engine\classes\class.dbConnections.php file and add sqlsrv command to $dbServices array

Capture.PNG (139.86 KiB) Viewed 33072 times

Then edit processmaker-3.2.1-0\apps\processmaker\htdocs\workflow\engine\classes\class.net.php file and add case for sqlsrv

Capture.PNG (133.39 KiB) Viewed 33072 times

class.dbConnections.phphttps://ufile.io/65gj4
class.net.phphttps://ufile.io/nk9gx

[amosbatto]

ashkufaraz,
Excellent work! Unfortunately, the dev team insists that we only use official Microsoft drivers, and they came up with a solution for PM 3.2.2 and it will be added to the wiki in the next couple weeks. However, I like your solution better, so I will recommend it for people using PM 3.2.1 and earlier.

[linkatree]

i have try this method with 3.2.2 but no luck, any workaround maybe?

[amosbatto]

linkatree,
Here is another alternative that you can try: viewtopic.php?f=40&t=709734&p=803961&hi ... ql#p809021

The dev team has compiled a MSSQL DLL for PHP 5.6 which works with ProcessMaker 3.2.2 and should be posted on the wiki. Sorry, I don't have access to the internal repo, so I can't give you the DLL now, but I will post a note here the moment it is available on the wiki for download.

[linkatree]

my installation is :
win 2008 r2 64 bit
sql server 2008
php 5.6 64 bit
process maker 3.2.2

it is possible to follow that workaround ?
since i saw the workaround using sql server 2012 and bitnami is 32 bit

[amosbatto]

I talked to the person who writes the documentation and she tells me that instructions for PM 3.2.2 and MSSQL should be posted on the wiki by the end of this week.

[amosbatto]

linkatree,
Attached are the DLL files to connect to MSSQL with PHP 5.6 (32 bit and 64 bit):

[linkatree]

Hi,

i try to load the x64 file but its error not a valid win32 ...

[amosbatto]

If you have 32 bit Windows, then only enable PHP_5_6_32_X86_php_dblib.dll in your php.ini file.
If you have 64 bit Windows with 32 bit PHP, then only enable PHP_5_6_32_X86_php_dblib.dll in your php.ini file.
If you have 64 bit Windows with 64 bit PHP, then only enable PHP_5_6_32_X64_php_dblib.dll in your php.ini file.

Please wait for the instructions on the wiki.

[linkatree]

i still have no luck with this,
any updates when wiki will update for this matter?

[ashkufaraz]

You can use this dll

PHP_5_6_32_x64_php_dblib.dll

(273.5 KiB) Downloaded 860 times

[linkatree]

i just try this file and still error it not valid win32

[linkatree]

I talked to the person who writes the documentation and she tells me that instructions for PM 3.2.2 and MSSQL should be posted on the wiki by the end of this week.

any updates for the wiki for this matter?

[amosbatto]

The documentation for using MSSQL with PHP 5.6 in Windows if now available on the wiki:
http://wiki.processmaker.com/3.2/Databa ... QL_Windows

Sorry about the delay.