ODBC crashes when sending multiple querys

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

Have you considered moving to a more heavyweight db server (mySql,
MSSQL) which can handle multiple queries?

Barand

http://members.aol.com/barryaandrew...agridguide.html easy
data tables - and more

----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

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

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

by the way ...

i fixed the problem, it's a microsoft issue with ODBC and FOX pro
that ASP and oether languajes to crash. it seems the option
"fetch data in the background" has to be taken out.

here is a link .

http://support.microsoft.com/defaul...b;EN-US;Q269881


cheers




----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums