Link to home
Start Free TrialLog in
Avatar of arkam chou
arkam chou

asked on

PHP MSSQL

Dear Expert,

How can I configure php in Wamp Server 2.5 with Microsoft SQL Server 2014?
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arkam chou
arkam chou

ASKER

How I know I do it right on my side? In the attachment are some information about my the configuration.
6-12-2015-6-55-03-AM.jpg
That looks Ok.  Did you install the SQL Native Client?  That is not part of WAMP.  Here's the 'man' page for 'sqlsrv':  http://php.net/manual/en/book.sqlsrv.php
I had install it already. how to check that it work right?
Try some of the examples from the 'man' page.  Did you also install SQL Server Management Studio so you can perform administrative functions like adding users?
I had take example from this link below but it got error as in attachment. I think it look not yet work extension because I saw it can not call function "sqlsrv_connect()".
http://php.net/manual/en/book.sqlsrv.php
6-12-2015-7-38-37-AM.jpg
As it shows on this page http://php.net/manual/en/sqlsrv.requirements.php , you Must have the SQL Native client installed before the 'sqlsrv' extension will work.
I download and install it already
6-12-2015-8-38-42-AM.jpg
6-12-2015-6-55-03-AM.jpg
No.  That is the PHP extension.  The SQL Native Client is a separate driver that is Required for the PHP extension to work.
I had test it on windows 8.1 64Bit. I install 64bit package from http://php.net/manual/en/sqlsrv.requirements.php but it not work then I install The Microsoft Drivers 3.2 from https://www.microsoft.com/en-us/download/details.aspx?id=20098 but it still not work again.
6-12-2015-6-25-19-PM.jpg
6-12-2015-6-26-05-PM.jpg
I don't know what else to tell you.  I don't have Windows 8, just Windows XP and the earlier versions worked Ok for me.
I had test with windows 7 32bit, it work fine. Anyone know how can use with windows 64bit?
Dear Dave Baldwin,

It also work when install wamp 32bit on windows 64bit.

Thanks,
You're welcome, I'm glad you got it working.