Why WPN-XM not integrated support for MSSQL?

This forum serves as discussion and support collaboration point for products and services of the WPN-XM project.
Trong
Posts: 1
Joined: Sat Mar 26, 2016 7:38 am

Why WPN-XM not integrated support for MSSQL?

Postby Trong » Sat Mar 26, 2016 7:51 am

Hi,
I can not find the MSSQL extension support in the WPN-XM.
WPN-XM can integrate it for the next version?

Best regards,
Trong

User avatar
jakoch
Site Admin
Posts: 13
Joined: Mon Dec 07, 2015 2:07 pm
Location: Berlin, Germany
Contact:

Re: Why WPN-XM not integrated support for MSSQL?

Postby jakoch » Mon Mar 28, 2016 6:27 pm

I can not find the MSSQL extension support in the WPN-XM.
Hi Trong,

the MSSQL extension is no more.
Its not available anymore on Windows since PHP 5.3+ and was fully REMOVED in PHP 7,
see http://php.net/manual/de/migration70.re ... -sapis.php

According to the PHP manual (http://php.net/manual/en/intro.mssql.php) your best alternatives are: My suggestion is to connect either via the PDO_ODBC driver or install the SQLSRV extensions provided by Microsoft.

The extension has a Github repository https://github.com/azure/msphpsql
You can read: "The release contains two drivers, the SQLSRV driver and the PDO_SQLSRV driver."
But this isn't true, because you'll find only the downloads for "php_sqlsrv_7_[nts|ts].dll". They are still working on the PDO versions.
WPN-XM can integrate it for the next version?
The driver is MIT licensed. So, yes, i can integrate and redistribute the SQLSRV extension starting with the next WPN-XM release version.

I've opened a new Github issue for this feature request: https://github.com/WPN-XM/WPN-XM/issues/550

Thank you for the feature request. I will keep you updated.

Regards, Jens

User avatar
jakoch
Site Admin
Posts: 13
Joined: Mon Dec 07, 2015 2:07 pm
Location: Berlin, Germany
Contact:

Re: Why WPN-XM not integrated support for MSSQL?

Postby jakoch » Sun Apr 24, 2016 12:26 pm

I could integrate it, but i don't want to automate the PHP extension fetching for an inconsistent naming scheme.
So:

The integration is on hold until the Azure guys fix issue 88,
which is a prerequisite for writing a proper crawler on base of a consistent naming scheme.
see https://github.com/Azure/msphpsql/issues/88

User avatar
jakoch
Site Admin
Posts: 13
Joined: Mon Dec 07, 2015 2:07 pm
Location: Berlin, Germany
Contact:

Re: Why WPN-XM not integrated support for MSSQL?

Postby jakoch » Tue Jun 07, 2016 9:12 pm

Update: Issue #555 was closed - https://github.com/WPN-XM/WPN-XM/issues/550

The PHP Extensions sqlsrv and pdo_sqlsrv are now integrated.
The full, standard and webinstallers of PHP7 will ship them out of the box.
Both extensions are available for selective download from our components page and via our API.

You just need to active them in php.ini, if you want to use them.

Best regards, Jens

User avatar
jakoch
Site Admin
Posts: 13
Joined: Mon Dec 07, 2015 2:07 pm
Location: Berlin, Germany
Contact:

Re: Why WPN-XM not integrated support for MSSQL?

Postby jakoch » Mon Feb 06, 2017 4:02 pm



Who is online

Users browsing this forum: No registered users and 1 guest