I’ve been struggling to get DF Beta 2 (rel 2) to connect to a local MSSQL database (MSSQL Express 2008, R2, 64bit). My OS is Win 7 Enterprise 64bit.
I’ve followed almost all of the instructions on this forum, DF website and http://robsphp.blogspot.co.za/2012/09/how-to-install-microsofts-sql-server.html (which is really helpful). The problem is that DF indicated that it couldn’t load the sqlsrv dll’s when trying to create a MS SQL DB service. I ensured the dll’s are for the correct PHP version (5.5.28) and referenced in the PHP.ini file as described in numerous places, but still no joy.
I then decided to see if I could get a MS SQL service setup in DF 1.9.4 and low and behold after all the relevant edits (as mentioned above) I got it to work without any problem.
But, and here is the but. For a particular project we need to use AD/LDAP authentication and this is only available in DF 2 as I can see from various posts and DF promo’s. I saw this morning that DF 2 Beta 3 was made available and I’ve decided to give it a go. I’ve installed the Bitnami stack for 64bit on my computer and managed to get it up and running without a hassle. I then made all the relevant tweaks as per above and restarting Apache. I then tried to create the MS SQL DB service again but still got the same error message. When I look at the log-file I get the following error/warning:
PHP Warning: PHP Startup: Unable to load dynamic library ‘C:/Bitnami/dreamfactory-2.0.beta-3/php/ext\php_pdo_sqlsrv_55_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:/Bitnami/dreamfactory-2.0.beta-3/php/ext\php_sqlsrv_55_ts.dll’ - %1 is not a valid Win32 application.\r\n in Unknown on line 0
I’m struggling to understand how this is possible since I’ve made sure to grab and copy the 64bit dll’s (extension=php_sqlsrv_55_ts.dll, extension=php_pdo_sqlsrv_55_ts.dll). I’ve even tried the 32bit versions still the same result.
Any assistance with this problem is highly appreciated.