Need to know what I need to get to connect apache php to sql 2008 on win2k8 sbs WAMP

I have a SBS 2008 server running the newest WAMP with the included MYSQL removed. We have SQL 2008 Enterprise installed and I want to use the PHP included with wamp to make a script that will grab data from our SQL 2008 database and put it into a file for me.

I believe I need some kind of drivers installed in the php ext directory in order to use those functions and I cannot seem to figure out where I can download that, and what the commands would be?

A direct download link and a link to some help on the command usage would be great.

I do have experience programming php with MYsql, but never sql 2008.
E J PopeAsked:
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 the Microsoft PHP SQL driver http://www.microsoft.com/download/en/details.aspx?id=20098 and the SQL Native Client.  It can be found in the middle of this page if you don't have it:  http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16978
0
Dave BaldwinFixer of ProblemsCommented:
There is a help file with the PHP SQL driver that shows the syntax required.
0
E J PopeAuthor Commented:
I already had the 2.0 of the sql driver downloaded and installed in the php ext dir and added "extension=php_sqlsrv_52_ts_vc6.dll
extension=php_pdo_sqlsrv_52_ts_vc6.dll"

to the php.ini file.

I tried to install that native client and it detects an older version of the native client. I don't want to break our sql server as a custom program was made to run on the exact setup we have. So I did not install the newest version of the native client.

I restarted apache and went to the phpinfo page and I cannot find anything saying SQL 2008. I did find one thing saying mysql though =\
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

E J PopeAuthor Commented:
Ah found a solution. This thread helped me out: http://forum.wampserver.com/read.php?2,68421

For some reason it just will not work unless you have a php version older than 5.3. WEIRD!
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
E J PopeAuthor Commented:
found it myself. which is why im rewarding points to myself..
0
Dave BaldwinFixer of ProblemsCommented:
Yes, the VC6 versions are for PHP 5.2 and below, VC9 versions are for PHP 5.3 and newer.  I have both of them running on different servers.  I understand not wanting to break the current software.  You might want to make a note for the future.  The transition from PHP 5.2 to 5.3 breaks a number of things in addition to requiring a different version of the Microsoft PHP SQL driver.
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
Microsoft SQL Server 2008

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.