ProcessMaker Forum | BPM Workflow Simplified

newways3000 wrote:I solved the issue in this way (for processmaker 3.2 php 5.6 using bitnami installer)

1. Put files

php_dblib.dll

and

php_sqlsrv_56_ts.dll

and

php_pdo_sqlsrv_56_ts.dll

in {php installed directory}/php/ext

2. Add this three lines to end of your php.ini (placed in {php installed directory}/php/ )

Code: Select all

extension=php_dblib.dll
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll

3. Extract file

creoleSqlServerDriver.rar

(use Extract Here in WinRar) to this location : {processmaker installed path}\apps\processmaker\htdocs\gulliver\thirdparty\creole\drivers (the folder named "mssqlsrv" must placed in mentioned folder )

4. Edit Creole.php (located in {processmaker installed path}\apps\processmaker\htdocs\gulliver\thirdparty\creole\ ) : line 88 :

Code: Select all

 'mssql' => 'creole.drivers.mssql.MSSQLConnection', 

to

Code: Select all

 'mssql' => 'creole.drivers.mssqlsrv.MSSQLSRVConnection', 

or simply replace Creole.php with file in zipped file

Creole.rar

Now it worked (at least for me!)
Actually with creole sqlsrv driver, we get rid of all mssql garbages that deprecated from php

bilalk wrote:hi newways3000,

i did what you told here. It didnt work for me. did you do anything except them?

or someone tried this method?

i did with manual installation but bitnami installer is better. can you check it please?

[*]Do EXACT Steps mentioned in [url=http://wiki.processmaker.com/3.0/Database_Connections]Processmaker guide[/url]

[*]If you do that , you will be able to create a connection to database in Database Connections successfully. If not so you must figure that out first.

[*] The actual problem is in processmaker driver for minipulating data. If you connect to database succesfully but cant -for example- fill a dropdown with sql server datasources then you must use presented driver in my answer.

newways3000 wrote:

bilalk wrote:hi newways3000,

i did what you told here. It didnt work for me. did you do anything except them?

or someone tried this method?

i did with manual installation but bitnami installer is better. can you check it please?

Hi

Can you tell what exactly you do and what exactly you get from machine? Explain with machin responses , browser outputs , screenshots or else.

Take this tips into consideration:

[*]Do EXACT Steps mentioned in [url=http://wiki.processmaker.com/3.0/Database_Connections]Processmaker guide[/url]

[*]If you do that , you will be able to create a connection to database in Database Connections successfully. If not so you must figure that out first.

[*] The actual problem is in processmaker driver for minipulating data. If you connect to database succesfully but cant -for example- fill a dropdown with sql server datasources then you must use presented driver in my answer.

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_sqlsrv_56_ts.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_sqlsrv_56_ts.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0

newways3000 wrote:

bilalk wrote:hi newways3000,

i did what you told here. It didnt work for me. did you do anything except them?

or someone tried this method?

i did with manual installation but bitnami installer is better. can you check it please?

Hi

Can you tell what exactly you do and what exactly you get from machine? Explain with machin responses , browser outputs , screenshots or else.

Take this tips into consideration:

[*]Do EXACT Steps mentioned in [url=http://wiki.processmaker.com/3.0/Database_Connections]Processmaker guide[/url]

[*]If you do that , you will be able to create a connection to database in Database Connections successfully. If not so you must figure that out first.

[*] The actual problem is in processmaker driver for minipulating data. If you connect to database succesfully but cant -for example- fill a dropdown with sql server datasources then you must use presented driver in my answer.

erpnedir wrote:Hi newways3000,
I face the same problem. I did a manual PM 3.2 install on Win Server 2012 R2, see the MsSQL at DB connection, pass the test and see the disappointing message the exact steps you mention: 'An internal error occurred #1511262315. Please contact your system administrator for more information.'
I also checked that my slashes ar backslash at php.ini, extension_dir. And still getting the same.
I noticed that Apache error log notes below two lines. Do you have any idea?

Code: Select all

PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_sqlsrv_56_ts.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\\php\\ext\\php_pdo_sqlsrv_56_ts.dll' - %1 is not a valid Win32 application.\r\n in Unknown on line 0

YolandaYan wrote:I've got an old project that still runs 5.3.9 and has supported connection to SQL Server. I would like to develop some new features and for that I would appreciate start using the latest version of PHP. But for what I've read there is no support to SQL Server. Any guide that allows me to connect PHP to SQL server in version 5.6?