|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Problem FlexODBC 4 with apache |
| Author |
Message |
|
|
| Posted : 2008-02-22 13:38:04 |
Hi...
I have a php (Windows+Apache+PHP) application reading data from a dataflex database by FlexODBC 4
Looks work fine with one user, but when 2 differents users try run 2 process at the same time, Apache just crash , on the apache's log I look [Thu Feb 21 09:02:04 2008] [notice] Child 2236: Starting 250 worker threads.
I grow to 400 and even 800 and the result is the same [Thu Feb 21 09:02:04 2008] [notice] Child 2236: Starting 800 worker threads.
Any idea?
Regards.... |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-02-22 18:29:41 |
| Unfortunately this is only a FlexODBC support forum, Apache errors don't help much. I suggest you check the operation of FlexODBC by running two seperate copies of VB Demo and see whether running two queries causes a problem or not. From there look at your PHP script and try opening and closing the FlexODBC connection after each database operation in your script. |
|
|
|
|
|
| Posted : 2008-02-24 15:08:19 |
I know is a FlexODBC forum, the info about apache is ilustrative you know that. Im not asking for a Apache support, Apache is a very stable software.
Are you saying I test FlexODBC driver??, better you answer me please.
The question direct is : is it possible make several connections at the same time by ODBC ???, per haps 10 ?
I receive many errors or warning with more than 1 user
Warning: odbc_exec() [function.odbc-exec]: SQL error: [FlexODBC] Data truncated, SQL state 01004 in SQLExecDirect in ....
another times apache crash (yes is not a Apache forum)
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-02-24 23:05:43 |
| Yes, I'm suggesting you TEST the operation of FlexODBC by running two seperate copies of VB Demo and see whether running two queries causes a problem or not. From there look at your PHP script and try opening and closing the FlexODBC connection after each database operation in your script. |
|
|
|
|
|
| Posted : 2008-02-25 04:19:52 |
| is it possible make several connections at the same time by FlexODBC ???, per haps 10 ? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-02-25 08:40:46 |
| Yes, it really depends on the loading of the application, some developers do silly SELECT * FROM tablename table scans, while others do quick record retrieves and inserts. |
|
|
|
|