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
|
|
Error message after system is running for a few days |
Author |
Message |
|
Posted : 2006-03-29 17:33:14 |
Hello,
I receive the following error message after my system has been running for a few days. I have QODBC v6.00.00.147 pointing to Remote Connector V3. I use PHP to access data.
Received in web browser: Warning: odbc_connect() [function.odbc-connect]: SQL error: [ODBC] QB Begin Session Failed. Error Calling OpenQBConnection, SQL state S0000 in SQLConnect.
I am also receiving this in the QODBC log: [ODBC] QB Begin Session Failed. Error Calling OpenQBConnection.
Any advise would be appreciated. Thanks, Brenton |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-03-29 19:35:13 |
Brenton,
You haven't said what the Remote Connector is connecting to at the other end and how (LAN or Internet)? The error is saying it can't open the connection to QuickBooks, which could be for any number of reasons.
Ideally you should close your connection and restart QODBC as a daily routine. QODBC is simply not mean't to be running for days on end.
Tom
BTW: A QODBC v6.00.00.150 update is available from: http://www.qodbc.com/download/qodbc.exe |
|
|
|
|
Posted : 2006-03-29 20:57:45 |
Thanks Tom. I just found that restarting apache sorts the problem out. I will schedule this on a daily basis from now on. Thanks for your prompt responce. |
|
|
|
|