Problem with PHP and sqlanywhere

[Former Member]

Hi all,

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?

Regards, ken

[regdomaratzki]

Ken, I've never used the SQL Anywhere PHP module (or any PHP module), but your question has gone unanswered, so I though I could ask for some more information and some clarifications on your post, hoping that maybe somebody else could answer.

1) What version and build of SQL Anywhere are you using, and on what OS? 2) When you say you restart the server, can I assume you mean the Apache Web Server? 3) Can you elaborate on what problems you see when you say that "none of them have worked" ?

[Former Member]

Hi Reg,

I've tried various builds of v11. The first one I just check is 11.00.01.2044.

The O/S's are listed above. The web server is IIS 6 and IIS 7 (win7)

And sadly there is no further description than 'none of them have worked'. PHP presents zero acknowledgement that the library is either loading or failing to load (confirmed by php -i). I am positive that the config file for php is the correct one, because I added another library (mbstring) and it did show up in the php info.

[Former Member]

Ken... did you look at this question? Maybe there is a clue in there that will help. http://sqlanywhere-forum.sap.com/questions/4691/php-warning-php-startup-unable-to-load-dynamic-libra...

[Former Member]

Thanks for the link. I looked through and it appears to pertain primarily to Linux, however, even with that, it doesn't appear as though any of it will apply, simply because I don't even get any acknowledgement that the drivers are even attempted to being loaded.

Thanks, Ken

[Former Member]

Well, after continued struggles with it, I finally figured out what is happening.

The only way to get the the error messages back from the php console is to run your command prompt in Administrator mode. Once I did that I could see that the SQL anywhere module is attempting to load, however, it is compiled in Thread-Safe mode which is not compatible with the FastCGI non-thread-safe mode.

Do you know if there is a way to get non-thread-safe versions of the module for windows?

Thanks, ken

[Former Member]

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.