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
|
|
IIS/PHP QODBC v8 and Quickbooks 2007/08 - QB Begin Session Failed. Error = 80040416 |
Author |
Message |
|
Posted : 2008-10-22 16:32:17 |
Running QODBC v8 with Quickbooks 2007/08, with a web-based application (IIS/PHP) on a webserver using QODBC, via Remote Connector to a second machine with Quickbooks installed. QODBC v8 is installed, and licensed (Desktop Read/Write) on both machines.
Identical set-up used to work with v6 and Quickbooks 2004, and I could have sworn I'd got it working in the new set-up a few weeks ago, but re-testing it today, I got into some trouble.
Initially it wouldn't work at all, then I checked the version on the webserver, and from the "About", it told me it was still v6. Re-Installing v8 in the same directory had no effect, then i determined that, for some reason, it wasn't over-writing the files in C:/Windows/system32 - I had to delete them and re-install v8 to get the latest binaries installed in that directory.
I checked it using VBDemo and it works fine - can connect OK, and query the database without any trouble.
BUT... when trying to access it via IIS/PHP, as before, i get the following error:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [QODBC] QB Begin Session Failed. Error = 80040416, If QuickBooks is not running, a call to the "BeginSession" method must include the name of the QuickBooks company data file. , SQL state S0000 in SQLConnect in ...\DisplaySQL.php on line 19
I have checked Quickbooks preferences (Integrated Applications) and all the permissions are set there, and I have given the web-usr IUSR_.. read/execute permissions on the binaries in Windows/system32, but that hasn't made any difference. I tried searching the forums, but it seems this error doesn't come up too often. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-23 08:17:16 |
|
|
|
|
Posted : 2008-10-24 14:16:40 |
Hi Tom, thanks for your comment, but it seems that the problem must have been caused by a Windows Security update on the server - by uninstalling QODBC, rebooting, then re-installing, the problem went away |
|
|
|
|