MSSQL

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MSSQL

Postby dkserver » 26. July 2012 06:57

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!
dkserver
 
Posts: 6
Joined: 26. July 2012 00:42
Operating System: WIN 2003

Re: MSSQL [Answered]

Postby JonB » 26. July 2012 20:37

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: MSSQL

Postby hackattack142 » 26. July 2012 22:07

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 )
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: MSSQL [Answered]

Postby dkserver » 27. July 2012 09:57

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
8)


Does it matter where I add thoes lines?
dkserver
 
Posts: 6
Joined: 26. July 2012 00:42
Operating System: WIN 2003

Re: MSSQL

Postby JonB » 27. July 2012 14:39

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 130 guests