Sqlsrv for PHP 5.6 on WAMP server

php sql-server apache dll wampserver
Danishdjinn picture Danishdjinn · Apr 7, 2016 · Viewed 27k times · Source

After looking so many posts about this problem, I don't understand why it don't work because it should be working. I will post all the information I have so far:

I downloaded SQLSRV32.exe from microsoft. I extracted the dll files to C:\wamp\bin\php\php5.6.16\ext.

In my php.ini given by wampserver:

  • extension_dir = "c:/wamp/bin/php/php5.6.16/ext/"

  • extension=php_sqlsrv_56_ts.dll

  • extension=php_pdo_sqlsrv_56_ts.dll

I have php5ts.dll in my php5.6.16 folder, so I think I have thread safe which is why I am using ts.dll ones.

If I'm in phpinfo() I should see a 'sqlsrv' section in there, but I don't see one, so I guess I did something wrong here somewhere?

I even did restart on wampserver many times and run as an administrator. It still don't show up on phpinfo()... But I can see this in php extension at the Wampserver: Extension showed up here

Any ideas to what I did wrong or why it don't show up in phpinfo()?

Answer

Danishdjinn picture Danishdjinn · Apr 8, 2016

I have found what was the problem.

It seems that I was using microsoft 32-bit sqlsrv driver, which don't work with wampserver 3 64-bit.

Official Microsoft SQL Server Driver for PHP: Here 32 bit - use this if you have a 32bit wampserver.

Unofficial Microsoft SQL Server Driver for PHP: Here 64 bit - use this if you have a 64bit server.

After using the unofficial version, it showed up on phpinfo()!

Anyway, I hope this answer is useful to people who have spend looking around for an answer in hours... or whatever, I hope it was useful.

Related questions

SQLSRV PHP for SQL Server for is not a valid Win32 application

Here is my setup Windows Server 2008 R2 64 bit Apache 2.4.4 64 bit PHP 5.4.15 32 bit (64 bit is still experimental), thread safe, VC9 compiler Microsoft SQL Server 2012 Native Client 64-bit Microsoft Visual C++ 2010 x86 and x64 I need to load Microsoft's SQLSRV library. I …

Read More
Fatal error: Call to undefined function sqlsrv_connect()

I have come across quite a few post regarding the same subject question, however I am still unable to resolve it and so I ask. I am trying to connect to sql in my php script. My connection string is: /* …

Read More
How to escape strings in SQL Server using PHP?

I'm looking for the alternative of mysql_real_escape_string() for SQL Server. Is addslashes() my best option or there is another alternative function that can be used? An alternative for mysql_error() would also be useful.

Read More