CODEWITHSUNDEEP
phpsql-serverapachewamp
Tiger
Tiger

Reputation: 45

Configuration Issues with SQLSRV for PHP for MSSQL

I am installing a configuration with WampServer 2.4:

- Windows 7 64-bit sp1
- WampServer 2.4 64-bit
- PHP 5.4.3 64-bit (came with the WampServer)
- Apache 2.4.4
- Microsoft SQL Server 2012 Native Client 64-bit
- Microsoft SQLSRV 3.0 (php_sqlsrv_54_ts.dll, php_pdo_sqlsrv_54_ts.dll and they are put in c:/wamp/bin/php/php5.4.3/ext/

And I edited the C:\wamp\bin\apache\Apache2.4.4\bin\php.ini with the lines:

- extension_dir = "c:/wamp/bin/php/php5.4.3/ext/"
- extension=php_sqlsrv_54_ts.dll
- extension=php_pdo_sqlsrv_54_ts.dll

And I restarted all the services from Wamp.

But I still couldn't see the SQLSRV section from phpinfo -- and of course my connection test program failed.

What might have gone wrong?

Can anyone help?

Upvotes: 3

Views: 12223

Answers (3)

dearsina
dearsina

Reputation: 5192

For those of you using a 64bit version of PHP, the unofficial dll files linked below will work:

http://robsphp.blogspot.co.uk/2012/06/unofficial-microsoft-sql-server-driver.html

I am using 64bit WAMP on a 64bit Windows Server and was about to call it quits before I found those DLL files. It's odd that the official DLLs don't work with 64bit PHP, but I'm glad I at least found a solution.

Upvotes: 6

Tiger
Tiger

Reputation: 45

I'm using just Apache 2.2 and PHP 5.4 in 32bit with SQLSRV 3.0 and it is now working. Note that the Thread Safe is set to Yes, thus SQLSRV ts.dlls should be used. It was a struggle. Hope this helps others.

Upvotes: 0

Gavin
Gavin

Reputation: 2183

Your issue is because you are using (or WAMP has given you) 64bit php, where as your sqlsrv driver is most likely 32bit.

Your solution is to switch to a 32bit version of php (The benefits of running in 64, are pretty much non existent anyway unless you need larger data types), or to recompile the sqlsrv driver in 64bit (Likely more trouble than it is worth).

Try a WAMP 32 bit version. http://www.wampserver.com/en/#wampserver-32-bits-php-5-4

Also if Apache and my-sql are of no consequence to you (they are just a web sever and and an sql database) you can install a WISP PHP Stack in a breeze using the web platform installer. http://www.microsoft.com/web/downloads/platform.aspx

Upvotes: 11

Related Questions