asked on

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.

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

E J Pope

ASKER

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 =\

ASKER CERTIFIED SOLUTION

E J Pope

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

E J Pope

ASKER

found it myself. which is why im rewarding points to myself..

Dave Baldwin

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.