CODEWITHSUNDEEP
phpapachexampp
Michael B
Michael B

Reputation: 1763

Cannot find php_sqlsrv extension - 5.3, threadsafe

I've followed the answer to this question to the letter:

Connection between MSSQL and PHP 5.3.5 on IIS is not working

I'm using XAMPP with threadsafe 5.3. I've copied the files to the extension directory (while leaving them in the /php folder) and I've added the extension lines:

extension=php_sqlsrv_53_ts.dll
extension=php_pdo_sqlsrv_53_ts.dll

When I do this, Apache fails to 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.

Except, obviously, that that file DOES exist in that spot, and php.ini is pointed at that extension directory.

What's the problem?

Upvotes: 4

Views: 11975

Answers (6)

user3933469
user3933469

Reputation: 1

I was getting the same error messages when I started the Drupal 7 stack 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. steps 1) Stop Drupal Stack 2) run the file: sqlncli.msi 3) restart Drupal, and no error messages.

Upvotes: 0

Rob
Rob

Reputation: 191

I have written a page that might help when installing the SQLSRV driver: http://robsphp.blogspot.co.uk/2012/09/how-to-install-microsofts-sql-server.html

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

Upvotes: 1

Michael B
Michael B

Reputation: 1763

Sadly, none of the answers addressed the issue or were avenues I had already explored.

I have decided to use the ODBC drivers with a SQL Server connection string, which seems to work fine, minus the fact I can't use MSSQL and SQLSRV native functions.

Upvotes: 1

Erty Seidohl
Erty Seidohl

Reputation: 4559

Wrong technology, but I was having problems getting WAMP to connect to MSSQL, with the same types of errors.

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

Even if that's not applicable to the OP, I hope someone finds this helpful!

Upvotes: 0

Abid Hussain
Abid Hussain

Reputation: 7762

See below url

php_sqlsrv.dll: gives error when checking PHP version but extension works

Read it:-

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

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

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

Hope that helps !

Upvotes: 1

covener
covener

Reputation: 17872

Windows reports this when a shared lib dependency of what you're loading is missing. Use depends.exe to view the dependencies of php_sqlsrv_53_ts.dll and make sure it's either previously loaded or in the shared library search path.

http://www.dependencywalker.com/

Upvotes: 1

Related Questions