Home > Archive > PHP SQL > August 2004 > ODBC crashes when sending multiple querys
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ODBC crashes when sending multiple querys
|
|
| forunculo 2004-08-18, 3:57 pm |
| Hi,
first off, i am using a windows machine with php 4 , apache 1.3.6
,odbc with MDAC 2.6 and jet 4.0 with service pack 8. so pretty up to
date.
I am reading FOXpro 7 tables from another computer. This two
computers are set as a Domain and have maped harddrives. (they are
note the PDC)
Everything worked like a charm and never had a problem submiting
querys since they were prety quick and i did not have many users
using the scripts.
Now it came to a point where i need to run a report which takes
about minute and a half to go thru all the records (about 500k) and
print the result .I made it work perfect BUT i noticed that if i
try to run any other script which access DIFFERENT tables using the
same ODBC driver (from other mahines and other scripts, completely
different to the report running) everything hangs, i
don't get the report (frezes) and the other query doesn't give
me any result either
Once i restart apache everything goes back to normal. and this is the
only way it will go back to working state.
i tried making two small scripts that will get some data and print it,
really small querys. I ran the first one and the other right after
but the same thing, so it's not a memory problem, and offcouse my
script time limit is set to enought to wait for the querys.
the apache log does not ouput anything special, just the killing of
the child when i restart apache
[Tue Jun 15 13:05:19 2004] [error] forcing termination of child #0
(handle 280)
so, if i try to send two request to obdc it frezees. the apache seems
to work fine because i can still access the website and surf thru it
, which leads me to beleive that PHP is working as wel, but i cannot
submit any more querys because they would just hang and don't
give me any output .... (oh by the way the IE doesn;t hang) the
scripts just dies there and the IE status bar frezzes too.
i Also tried using odbc_connect AND odbc_pconnect with no luck. i am
comlpetly frustrated ... i have days debuging and can't find the
problem :( : :
has anyone experience this before ?
THANKS in advance for any help you can give me.
:)
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
| |
|
|
| forunculo 2004-08-18, 3:57 pm |
| i wish i could, but it's a switch software that runs on fox and i
cannot move it to mysql.
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
| |
| forunculo 2004-08-18, 3:57 pm |
| by th way
i installed PHP5 and apache 2 but it does the same exact thing ...
is there a limitation of connections on OBDC?
----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums
| |
|
|
|
|
|