Page 1 of 1

xampp 7.0 -sql server 2012r

PostPosted: 17. March 2016 10:44
by kesatas
hello , i have latest xamp 7.0 version with php 7 and its not connecting to mssql ^using sql server 2012r^ i add microsoft sql/php latest drivers 5.6 to ext folder and php.ini added nwtslib.dll and add old php_mssql.dll/php_pdo_mssql.dll and its still not working ... maby any ideas how to make it work ... im using windows server 2012r, thx for answers

Re: xampp 7.0 -sql server 2012r

PostPosted: 17. March 2016 12:03
by Altrea
Hi,

kesatas wrote:i add microsoft sql/php latest drivers 5.6 to ext folder and php.ini added nwtslib.dll and add old php_mssql.dll/php_pdo_mssql.dll and its still not working

Of course not! Microsofts latest officially released drivers are compiled for PHP 5.6 (as the name already says) only.
There are no PHP 7 compiles available, just an early technical preview: https://github.com/Azure/msphpsql/releases/tag/v4.0.0

My recommandation is to use XAMPP 5.6.X instead of XAMPP 7 yet.

best wishes,
Altrea

Re: xampp 7.0 -sql server 2012r

PostPosted: 17. March 2016 14:11
by kesatas
its the same problem with xampp 5,6 :/// maby its can't wor with sql 2012 and windows server 2012r ?
maby xampp team have specialist who can log in to vps via vnc and look ?

Re: xampp 7.0 -sql server 2012r

PostPosted: 17. March 2016 20:55
by Altrea
https://msdn.microsoft.com/en-us/library/cc296170(v=sql.105).aspx

[...] SQL Server 2008 or later if using version 3.2 or 3.1 [...]


Supported operating systems for version 3.2 and 3.1 of the driver include:
[...]
  • Windows Server 2012 R2
[...]

Re: xampp 7.0 -sql server 2012r

PostPosted: 18. March 2016 00:38
by kesatas
Thx for your help .. I think something blocking xampp in my Vps I will try to find solution :// but it's really weird :(

Re: xampp 7.0 -sql server 2012r

PostPosted: 19. March 2016 10:30
by kesatas
Solution is : MSSQL Connection working only with xampp1,7,x version(its got php_mssql.dll extension already inside) other versions supported only SQLSRV (1,7 is old wersion and fully working only with old sql server versions like 2005-2008 )
for me is only 1 solution wayt for new xampp maby its will got inside mssql connect to sql server 2012 :)
anyway thx for help !