Shockingly, it seems that every server I have tried to get the sqlanywhere php module installed will not work. It is like it completely ignores it. I've tried on the following systems;
Windows 2003 32-bit 5.2.17 Windows 2003 32-bit 5.2.8 windows 7 32-bit 5.2.14
I first determine where the php.ini is being loaded from and edit the appropriate one and put the extension=sqlxxxxx line in there.
I then restart the server and sadly none of them have worked. If I jump out to a command prompt and try the php -i, it is not display any errors whatsoever.
Any suggestions on the above would be appreciated.
My next question is the whole reason I'm trying to install the above php module. What we are seeing on a Server 2008 RC2 is anytime there is a php connection through ODBC using the sqlanywhere drivers, if the database server hangs or takes longer than normal to respond, no other php requests behind that call will be executed. It looks as through PHP is hanging, but in fact it is the database request causing the hang. Any suggestions on what we could do to change this behavior?
You can get a non-thread-safe version of the PHP module from The SQL Anywhere PHP Module Download. Make sure you download the correct one for your PHP version and OS. The non-thread-safe ones are under the "Single Threaded" column.