SQL Server - PHP Unable to Load


#1

I’m unable to configure the SQL server service. I’ve add the extension to the php.ini and php tries to load, however I receive the following errors.

PHP Warning: PHP Startup: Unable to load dynamic library ‘C:/Bitnami/dreamfactory-2.0.beta-3/php/ext\php_sqlsrv_55_nts.dll’ - The specified module could not be found.\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_pdo_sqlsrv_55_nts.dll’ - The specified module could not be found.\r\n in Unknown on line 0

I’m running windows 10 and 64 bit. I’ve found the php 64 drivers, however still no success. Has anyone had similar issues, and/or resolved

Bob


#2

Sorry, also running Dreamfactory 2.0 Beta 3.

Bob


#3

Bob, you should be using the thread safe dlls
php_sqlsrv_55_ts.dll
php_pdo_sqlsrv_55_ts.dll
The non thread safe are typically only used with IIS

Also, make sure you don’t have any transcription errors in the php.ini file. I’ve found it to be very easy to mistype these file names.


#4

Also, if you are referencing the 64 bit drivers from here: http://robsphp.blogspot.com/2012/06/unofficial-microsoft-sql-server-driver.html
Please know there are some questions about their compatibility with newer versions of SQL Server. Still trying to get a handle on what is and is not supported by these drivers.


#5

Thanks all working.

  1. Changed to php_sqlsrv_55_ts.dll & php_pdo_sqlsrv_55_ts.dll
  2. I was using robs 64 bit versions, however not the TS.

Bob