Until today, I've been connecting to our Informix server using PHP's ODBC functions. However, I was able to get the Informix functions to work today and initially, they seemed to work great.
However, after a bit of testing, I am getting inconsistent results. If I run the same script over and over, 75% of the time it will work fine. Sometimes it will return this error:
PHP has encountered an Access Violation at 701CBB52
Other times it will return this error:
Warning: ifx_query() [function.ifx-query]: Open cursor fails (E [SQLSTATE=IX 000 SQLCODE=-200]) in C:\Inetpub\intranet_test\collections_queue_edit.php on line 82
I really would rather use the Informix functions, but not if they are going to be buggy like this. Any ideas or feedback?