Apache Friends Support Forum

Hey guys can MSSQL work on xampp 1.8.0, also if it does, can you tell me how to conifgurate it to make it work?

Another thing, if it's not working I saw that it's can work on 1.7.7 from hackattack

http://community.apachefriends.org/f/viewtopic.php?f=16&t=49670&p=191610&hilit=SQLSRV#p191618

What do you mean by extension lines, sorry for the igoarnce, but I am new to xampp..

Thanks in advance!

He means to add a line to your php.ini file for each of the PHP 'extension name' and the .dll .

Code: Select all

extension = yourpathtofile\php_pdo_sqlsrv_53_ts_vc9.dll
extension = yourpathtofile\php_sqlsrv_53_ts_vc9.dll

Good Luck

Yes, but I want to clarify something because you are using an older OS. In your case, you will probably not be able to use the MSSQL/SQLSRV drivers with XAMPP 1.8.0.

XAMPP 1.8.0 contains PHP 5.4.x and SQLSRV 3.0 drivers contain the correct libraries for PHP 5.4.x but SQLSRV 2.0 only goes up to PHP 5.3.x

SQLSRV 3.0 has dropped support for all OS's under Vista and Server 2008 (which means those drivers as well as the Microsoft SQL 2012 Native Client required by the 3.0 drivers will not install on Win Server 2003).

You will most likely need XAMPP 1.7.7 to get PHP 5.3.x which are compatible with the SQLSRV 2.0 drivers. You should be able to mostly follow those instructions in the other link you found (Just make sure you get the SQLSRV20.exe download and the Microsoft SQL Server 2008 R2 Native Client from here(about halfway down the page): http://www.microsoft.com/en-us/download ... x?id=16978 )

JonB wrote:He means to add a line to your php.ini file for each of the PHP 'extension name' and the .dll .

Code: Select all

extension = yourpathtofile\php_pdo_sqlsrv_53_ts_vc9.dll
extension = yourpathtofile\php_sqlsrv_53_ts_vc9.dll

Good Luck

Does it matter where I add thoes lines?

dkserver:

I don't think it will matter, but I would put them where the other extension declarations are so you can find them easily.

I 'think' the instance variables are all read into an array by the PHP handler and that 'sorts things out', but Altrea or hackattack142 might know a more accurate answer.

As hackattack pointed out - that is a fix for 1.7.7. You are going to try it that way, correct?

If you switch to 1.7.7, please update your profile so we know what version you are on for now, if you have more questions

Good Luck