PHP MSSQL

Dear Expert,

How can I configure php in Wamp Server 2.5 with Microsoft SQL Server 2014?
arkam chouAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
You need to get the 'sqlsrv' extension / driver from Microsoft along with the SQL Native Client.  The old 'mssql' extension does not work with PHP 5.3 or newer.  https://msdn.microsoft.com/en-us/data/ff657782

The SQL Native Client is available at https://www.microsoft.com/en-us/download/details.aspx?id=36434 .
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
0
arkam chouAuthor Commented:
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
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dave BaldwinFixer of ProblemsCommented:
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
0
arkam chouAuthor Commented:
I had install it already. how to check that it work right?
0
Dave BaldwinFixer of ProblemsCommented:
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?
0
arkam chouAuthor Commented:
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
0
Dave BaldwinFixer of ProblemsCommented:
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.
0
arkam chouAuthor Commented:
I download and install it already
6-12-2015-8-38-42-AM.jpg
6-12-2015-6-55-03-AM.jpg
0
Dave BaldwinFixer of ProblemsCommented:
No.  That is the PHP extension.  The SQL Native Client is a separate driver that is Required for the PHP extension to work.
0
arkam chouAuthor Commented:
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
0
Dave BaldwinFixer of ProblemsCommented:
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.
0
arkam chouAuthor Commented:
I had test with windows 7 32bit, it work fine. Anyone know how can use with windows 64bit?
0
arkam chouAuthor Commented:
Dear Dave Baldwin,

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

Thanks,
0
Dave BaldwinFixer of ProblemsCommented:
You're welcome, I'm glad you got it working.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.