Re[2]: [PHP-WIN] Disabling ODBC

> what problems do you have with PHP & Access? I don't think > plain existence of odbc functions in PHP causes problems (at > least I haven't experienced any problems with them), so just > stop using Access from PHP, install MySQL, and use it from > PHP. Some problems: 1. Whenever a PHP script that calls a ODBC-Access 95 query is invoked, I get 100% CPU usage for the time the script runs. This, as explained later, only with PHP as CGI. 2. Erratic PHP crashing. Sometimes a certain script crashes, sometimes it doesn't. All crashes *seem* (not certain, as I have no way of determining who crashed php) to be caused by ODBC-running scripts. Since they are non-reproduceable, I can't post a bug report. 3. No crashes whatsoever on MySQL-running scripts. No 100% CPU usage even in complex or long queries. 4. These PHP crashes are just that: crashes. The script gets executed 100%, the server is not blocked, even apache and php work correctly with the crash dialogue on screen. But after several of these crashes I get a BSOD that messes my display; and after a couple of BSODs, the computer really gets fouled up and I must reboot. This crashes are exasperating, since I can't pin down what is causing them as scripts get fully executed and HTML gets sent perfectly: clients don't notice any problem. 5. This happens both with CGI and Apache module, but since with module the running application is not PHP but Apache, I get apache crashes instead of PHP. Same results and situation as described before. 6. I've tried this on several computers (Celeron 333, Pentium III 450, Celeron 550, different brands), on Win95 and Win98 (no NT yet, but If I have to switch OS, I'll go to Linux). 7. When I'm running PHP as apache module, CPU usage goes to 100% full time after any ODBC script execution. 8. Under apache module, Win95 hot-keys (for invoking applications) suffer a 5-10 second delay before launching the app: same thing happens (with a little less delay) when Access 95 is running and I use hot-keys. Seem related. 10. On one installation, apache running with PHP module locked an Eudora starting. I had to shut down apache, run Eudora, and then run apache again, then everything was ok. I've double checked for multiple msvcrt.dll and other dll's lying around, and I'm running only with the version that ships with php 4.0.4. As you can see, I do have trouble, and the worst part is that I CAN'T FIND OUT WHAT IS CAUSING IT (sorry for shouting... :( ), so as far as I can see, the trouble comes from the Jet Engine, an thus, from using Access 95. What Access version do you use? Well, this was long... any ideas? Thanks, Gonzalo. > At 18:11 8.1. 2001, Gonzalo Vera wrote the following: > -------------------------------------------------------------- >>Hi All: >> >>Is there a way to disable ODBC support in PHP 4.0.4. I've been having >>all kinds of trouble because I use Win 95 and Access 95, and since I >>finally narrowed -I hope so- my problem to the Access Jet engine, I'm >>switching to MySQL (that's not an easy task, I have a lot of time >>invested in Access applications). >> >>But to get PHP running as a Module again (trouble is mostly, but not >>exclusive, with the apache module) I want to rid completly of the ODBC >>support. If I remove Access from the server, will I disable ODBC >>support? Or do I need to build a new PHP without ODBC (I really don't >>know how to do this)? >> >>BTW, anyone out there using Access 95, or am I the only caveman still >>clinging to oldies? >> >>Thanks, >> >>Gonzalo. >> >> >> >>-- >>PHP Windows Mailing List (http://www.php.net/) >>To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >>For additional commands, e-mail: php-windows-help@lists.php.net >>To contact the list administrators, e-mail: php-list-admin@lists.php.net > ------end of quote------ > ____________________________________________________________ > Cynic: > A member of a group of ancient Greek philosophers who taught > that virtue constitutes happiness and that self control is > the essential part of virtue. > cynic@mail.cz