arkam chou
asked on
PHP MSSQL
Dear Expert,
How can I configure php in Wamp Server 2.5 with Microsoft SQL Server 2014?
How can I configure php in Wamp Server 2.5 with Microsoft SQL Server 2014?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
More info here: https://www.experts-exchange.com/questions/28688226/SQL-Native-Driver-for-SQL-2014.html
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
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
ASKER
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?
ASKER
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
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.
ASKER
No. That is the PHP extension. The SQL Native Client is a separate driver that is Required for the PHP extension to work.
ASKER
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
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.
ASKER
I had test with windows 7 32bit, it work fine. Anyone know how can use with windows 64bit?
ASKER
Dear Dave Baldwin,
It also work when install wamp 32bit on windows 64bit.
Thanks,
It also work when install wamp 32bit on windows 64bit.
Thanks,
You're welcome, I'm glad you got it working.