PHP 8.x driver for SQLAnywhere

[justin_willey]

The question of a PHP v8 driver for SQL Anywhere is becoming very urgent.

The latest version for which a SQL Anywhere driver is available (here) is PHP v 7.4. Active support for this finished in November last year and Security Support finishes in November this year. The current support PHP version is 8.1 - details are here

We tried to compile a new version of the SQL Anywhere driver from source but without success. The main issue between v7.4 & v8.x relates to the thread safe behaviour and the removal of the Zend module from PHP. There also seem to be significant changes to the error handling. We tried to adapt the code to cope with these differences but were unable to make it work.

We have several customers who use PHP with SQL Anywhere who currently have no way forward.

[justin_willey]

apohl asked about this last year but there was no reply: https://sqlanywhere-forum.sap.com/questions/37078

[Oleksandr_Kushnirov]

I support. The lack of a driver stops the development of new solutions. SAP solve this problem

[RADical_Systems]

Update for everyone. The 8.1 and 8.2 dll's are available from SAP but apparently they can't be added to the dll page, (maybe someone lost the login)! Anyway for those in need here are the links:

Linux:
8.1
8.2

Windows:
8.1
8.2

[VolkerBarth]

Hm, if someone requires DLLs officially provided by SAP because of auditing, I'm not sure these links will do - but thanks for the info and links anyway!

[Oleksandr_Kushnirov]

Thanks Justin! Version 8.1 Thread Safe for Windows works great! Version 8.2 will try later

[RADical_Systems]

Volker - that's very true but it's a step closer! I have passed them to my client and hoping that my support trail with SAP gives them the confidence but you're right that it may not help greatly for those with access to such. |Hoping SAP can post them to the relevant page at some point.

[VolkerBarth]

@Chris Keating: Can we expect to get the 8.1. and 8.2. DLLs via the official wiki page?

[chris_keating]

The SAP SCN Wiki has been retired and its content moved to a location on the SAP Help portal. All SCN was made read-only in March to allow for the transition and I had been unable to update the page as a result. Now that the new location is active and a few issues resolved, I have finally been able to update the page with the links. The new location is: https://help.sap.com/docs/SUPPORT_CONTENT/SQLANY/3362971282.html?q=php. You will be redirected to this page if you use the SAP SCN Wiki link.

[former_SQLA_member1695075]

Hi Team,

Sql anywhere driver for php 8.1 / 8.2 well work for mod_php but not working for php-fpm.

Is anybody facing same issue, is there any solution

[VolkerBarth]

I'd suggest to ask that as a new question and to explain what exactly is "not working" for php-fpm... do you get error messages?

Do you use a thread-safe or non thread-safe SQL Anywhere PHP extension?

[former_SQLA_member1695075]

Hi,

NOw it is working as we have missed entry in environment variable

Thanks