Cannot find php_sqlsrv extension - 5.3, threadsafe

Question

I completed the answer to this question in a letter:

The connection between MSSQL and PHP 5.3.5 on IIS does not work

I am using XAMPP with threadafe 5.3. I copied the files to the extension directory (leaving them in the / php folder) and I added the extension lines:

extension=php_sqlsrv_53_ts.dll extension=php_pdo_sqlsrv_53_ts.dll 

When I do this, Apache does not start, giving me errors in eventvwr like:

 Application popup: Warning : PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv_53_ts.dll' - The specified module could not be found. 

In addition, it is obvious that this file exists in this place, and php.ini is indicated in this extension directory.

What is the problem?

Answer 1

Unfortunately, none of the answers touched on the issue or were prospectuses that I have already studied.

I decided to use ODBC drivers with the SQL Server connection string, which seems to work fine, minus the fact that I cannot use the native MSSQL and SQLSRV functions.

Answer 2

Windows reports this when there is no general dependency on what you are loading. Use the depend.exe file to view the dependencies of php_sqlsrv_53_ts.dll and make sure that it is loaded earlier or in the shared library search path.

http://www.dependencywalker.com/

Answer 3

See URL below

php_sqlsrv.dll: gives an error when checking the version of PHP, but the extension works

Read: -

With PHP 5.3, Microsoft has a new driver for windows:

http://msdn.microsoft.com/en-us/sqlserver/ff657782.aspx

Perhaps you can try this version, which seems quite recent (06/2011)

Hope this helps!

Answer 4

I wrote a page that can help with installing the SQLSRV driver: http://robsphp.blogspot.co.uk/2012/09/how-to-install-microsofts-sql-server.html

Unfortunately, the instructions were complicated when MSFT removed the download for the old XP / 2003 driver (version 2.0), so read the entire page before starting it.

Answer 5

The technology is wrong, but I had problems getting WAMP to connect to MSSQL with the same types of errors.

I fixed the problem by installing a 32-bit version of WAMP (instead of 64, although we were on a 64-bit system).

Even if this does not apply to the OP, I hope someone finds this useful!

Answer 6

I received the same error messages when I started downloading Drupal 7 after installation. I am using VM Ware with Win 7 x64 and acquia-drupal-win-7.31.36-6159.54300.

I went to the PHP site http://php.net/manual/en/sqlsrv.requirements.php and installed the x64 package. measures 1) Stop Drupal Stack 2) run the file: sqlncli.msi 3) restart Drupal and no error messages.