MSSQL SERVER IN XAMPP 5.6.3

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

MSSQL SERVER IN XAMPP 5.6.3

Postby ekoralesiya » 18. February 2015 09:23

Dear All,
please give me advice for activate php_mssql in php 5.6.3
i have downloaded unofficial dll for mssql for php 5.6.3 and remove semicolon on php.ini.

when apache services started no startup error.
but when i check on phpinfo, mssql not active.

i see on phpinfo in configure command
cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--with-pdo-oci=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--without-analyzer" "--with-pgo"

is it caused by parameter --without-mssql?
so how to change the configure command?

thanks.
Eko
ekoralesiya
 
Posts: 1
Joined: 18. February 2015 09:16
Operating System: WINDOWS SERVER 2012

Re: MSSQL SERVER IN XAMPP 5.6.3

Postby Altrea » 18. February 2015 12:14

If you want to use this inofficial library you need to compile PHP on your own with the new compiler flags.
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: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MSSQL SERVER IN XAMPP 5.6.3

Postby studio_two » 06. May 2015 13:31

So, just to clarify, there is no support for Microsoft SQL Server within 5.6.3?

I also tried to enable "extension=php_mssql.dll" within php.ini, but "php_mssql.dll" isn't present within the "php\ext" folder.


Thanks in advance,
Stephen
studio_two
 
Posts: 11
Joined: 28. June 2010 15:01
Location: UK
XAMPP version: 5.6.12
Operating System: Windows 7 Professional

Re: MSSQL SERVER IN XAMPP 5.6.3

Postby Altrea » 06. May 2015 14:20

studio_two wrote:So, just to clarify, there is no support for Microsoft SQL Server within 5.6.3?

Not build in, but you can add support for Microsoft SQL server by adding php_sqlsrv.
You can download the drivers from Microsoft: http://www.microsoft.com/en-us/download ... x?id=20098

studio_two wrote:I also tried to enable "extension=php_mssql.dll" within php.ini, but "php_mssql.dll" isn't present within the "php\ext" folder.

This will not work. PHP is not compiled with php_mssql. You need to use php_sqlsrv
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: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MSSQL SERVER IN XAMPP 5.6.3

Postby studio_two » 08. May 2015 08:55

Altrea,

Thank you so much for the clarification.

I have...
[1] Copied "php_pdo_sqlsrv_56_ts.dll" and "php_sqlsrv_56_ts.dll" into the "\xampp\php\ext" folder
[2] Commented out ";extension=php_mssql.dll" (within php,ini) and added:
extension=php_pdo_sqlsrv_56_ts.dll
extension=php_sqlsrv_56_ts.dll

Everything now loads correctly and I am able to connect to the Database (using a test php script).

I then had an additional problem, as my web pages still didn't work (even though the DLL's were loading). I was receiving a PHP error relating to "mssql_pconnect()".

It turns out that the RAD software (CodeCharge Studio 4.3) I used to develop my application doesn't support the new SQLSRV DLL (which uses "sqlsrv_connect()" instead). I had to upgrade to the latest version of CCS (and re-build my pages) to get fully up and running.

Many thanks for your help.

Kind Regards,
Stephen
studio_two
 
Posts: 11
Joined: 28. June 2010 15:01
Location: UK
XAMPP version: 5.6.12
Operating System: Windows 7 Professional


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 35 guests