Xampp 1.8.3 with MSSQL Connection

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

Xampp 1.8.3 with MSSQL Connection

Postby jfreak53 » 25. September 2014 16:06

I'm trying to install MSSQL connection ability and drivers in PHP 5.5 with Xampp 1.8.3.

I downloaded the file from this post here as I could not find the DLL anywhere else for 5.5:
Image

URL of Post:
http://sqlsrvphp.codeplex.com/discussions/441706

I then copied the files to the C:\xampp\php\ext folder and added them to the php.ini file:

Image
Image

But yet phpinfo shows no MSSQL:
Image

This is the error in my log file:

Code: Select all
[25-Sep-2014 14:22:11 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv_55_ts.dll' - The specified module could not be found. in Unknown on line 0
[25-Sep-2014 14:22:11 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_pdo_sqlsrv_55_ts.dll' - The specified module could not be found. in Unknown on line 0


Any help would be appreciated please. Thanks.
jfreak53
 
Posts: 3
Joined: 25. September 2014 15:57
Operating System: Windows

Re: Xampp 1.8.3 with MSSQL Connection

Postby Nobbie » 25. September 2014 20:17

This is one of the major disadvantages of using Xampp, you cannot simply copy any DLL from somewhere into PHP and expect it working - this does not work in most cases (as here). If you need MSSQL Support and there is no Xampp DLL, you should go for another solution than Xampp. Mixing up executables and DLLs from different distributions does not work.
Nobbie
 
Posts: 8770
Joined: 09. March 2008 13:04

Re: Xampp 1.8.3 with MSSQL Connection

Postby Altrea » 26. September 2014 06:25

http://www.apachelounge.com/viewtopic.php?t=6123

Download the php release from here and extract the php_sqlsrv.dll and php_pdo_sqlsrv.dll from the ext folder.
I could successfully start Apache with these php extensions.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Xampp 1.8.3 with MSSQL Connection

Postby jfreak53 » 26. September 2014 15:10

Same problem as before:

Code: Select all
[26-Sep-2014 14:12:05 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv.dll' - The specified module could not be found.  in Unknown on line 0
[26-Sep-2014 14:12:05 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_pdo_sqlsrv.dll' - The specified module could not be found.  in Unknown on line 0
[26-Sep-2014 14:12:08 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_sqlsrv.dll' - The specified module could not be found.  in Unknown on line 0
[26-Sep-2014 14:12:08 UTC] PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_pdo_sqlsrv.dll' - The specified module could not be found.  in Unknown on line 0


I downloaded this link:
https://phpdev.toolsforresearch.com/php-5.5.17-Win32-VC11-x86.zip
jfreak53
 
Posts: 3
Joined: 25. September 2014 15:57
Operating System: Windows

Re: Xampp 1.8.3 with MSSQL Connection

Postby jfreak53 » 26. September 2014 15:41

It seems that the PHP path was the only thing that was needed! So I added the PHP path C:\xampp\php to the Environment Variables in Windows 2008 R2 and it worked like a charm :) Thanks to everyone.
jfreak53
 
Posts: 3
Joined: 25. September 2014 15:57
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests