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
|
|
TestDCOM.php |
Author |
Message |
|
Posted : 2008-08-23 06:14:35 |
On machine A I can see the 3 user lines that come back from TestDCOM.php . Each line has ??????? . On machine B however I can't see any of these 3 user lines at all when spit out of the php. However, on machine B, the matrix shows all successful. Should I worry about these 3 lines not showing up? Will it affect performance of my QODBC?
I am having the problem, when I am using a web form based on the QODBC, that after a while apache crashes. So to state again. When viewing data through php, everything is good untill I let a webpage sit idle and then try to query data again through php.
Browse around where php querys data --- all good. Stop and talk to someone about it and then try to query again and apache crashes.
Is there any difference or preference of using apache on windows vs IIS ? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-23 07:44:50 |
Unfortunately this is only a QODBC support forum, Apache errors don't help much. I suggest you check the operation of QODBC 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 QODBC connection after each database operation in your script. And if opening and closing causes the crash, leave the connection open until the script is terminated. IIS and Windows gets around these issues by basically not closing connections until the service is terminated.
In .NET applications we have to use the STA (Single-Threaded Apartment) model so that only one query is executed at a time. The same applies to PHP, queries need to executed one at a time. I'm guessing that Apache could crash if a second query is executed before the first one completes.
Another thing, your QuickBooks company file must be running in Multi-user mode. |
|
|
|
|