|
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
|
|
| QB Begin Session Failed. Error = 80040408, Could not start Quickbooks - ASP |
| Author |
Message |
|
|
| Posted : 2008-10-02 02:05:11 |
I'm trying to get QODBC version 8 to work with QuickBooks 2006 Premiere, the VB Demo works, get's table names & customers from various DSNs and connection strings, when I try to access QuickBooks through my IIS 5.1 ASP.NET 2.0 website it fails, I ran the "TestDcom.asp" page, and everything succeeded.
QODBC ASP DCOM Access Test Page
| QB2002 | QB2003 | QB2004 | DCOM | COM | Object Name | Status |
| • |
• |
|
• |
|
QBXMLRPEQODBCInteractive.exe |
Success |
| • |
• |
|
|
• |
QBXMLRP.dll |
Success |
| |
|
• |
• |
|
QBXMLRP2EQODBCInteractive.exe |
Success |
| |
|
• |
|
• |
QBXMLRP2.dll |
Success |
| • |
• |
• |
|
• |
XERCES-COM.dll |
Success |
When I use "QBCust.asp" I get this:
________________________________________________________________________
QODBC Customer Web List Demo Page
Preparing to Create Connection Object
ADO Connection Created
ADO Recordset Created - Opening QuickBooks Sample Company File
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.
/internal/Common/QBCust.asp, line 30
______________________________________________________________________________
I've looked over the forum for answers to this but have not found anything that helps.
I've tried using the application with QuickBooks Open, and Closed, and I've used the QODBC GUI to test the connection to QuickBooks successfully.
I'm pretty sure I don't need to check ( How do I connect to QuickBooks for the first time? ) because I'm getting positive test results.
I'm also pretty sure I don't need to see ( How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? ) because I get positive test results.
I'm using QODBC v 8 Trial, (DCOM box checked on each DSN) (downloaded 2 days ago)
Windows XP Pro
QuickBooks 2006 Premier Edition Release R12P (Registered)
IIS v5.1
ASP.NET v2.0
Any Suggestions?
Mark. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-10-02 10:11:59 |
Incorrect, your DSN and Company file must be setup for unttended mode access as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? and QuickBooks must not be running already, otherwise the IIS Windows Service will get a: [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks error (as it's already running as a foreground task).
BTW: QuickBooks can only have one company file open at any one time and Windows doesn't release a connection from IIS for up to 10 minutes. |
|
|
|
|
|
| Posted : 2008-10-04 03:18:25 |
Ok, I'm pretty sure I had all of that setup ( How do I setup QODBC to auto-login into QuickBooks and start it if it's not running?), since I was getting data back from the VB Demo (is that correct?).
I restarted the server, did nothing else and tried the QBCust.asp page, and now I get no error, but the page hangs in the middle of loading. The CPU utilization on the Server spikes for a little bit, but then goes down.
I see 2 qbXMLRP2eQODBCInteractive.exe processes in the task manager of the server, but they appear to be idle after a little while.
I'm curious what the cause of the page failing to load completely is. I'd assume it's not actually making a connection to QuickBooks, but that makes me wonder why it's not coming back with an error.
Have you seen this issue before? Is it a problem with Auto-Login? If so, why can the VB Demo Auto-Login, and not IIS Via the DCOM Components?
Thanks,
Mark. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-10-04 11:22:41 |
|
|
|
|
|
| Posted : 2008-10-08 05:58:12 |
I've checked permissions on the C:\Program Files\QODBC Driver for QuickBooks folder, I've got INTERACTIVE, IUSR_<machinename>, and ASPNET with full control, as well as "EVERYONE" will full permissions, I've also re-checked the How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? Link, and cannot find any descrepancy.
Can you describe some possibilities why the VBDemo works yet the IIS connection doesn't? Does the qbXMLRP2eQODBCInteractive.exe process rely on QBXMLRP2e.exe? How does the QODBC process interact with the QuickBooks interface? Do I need the QuickBooks SDK components installed?
If I'm getting QuickBooks Data from the VBDemo, from a particular DSN (setup for a particular file with no QuickBooks instance open), does that mean that the auto-login works for that DSN?
Thanks Tom, Mark. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-10-08 07:44:34 |
| VB Demo is an application, while IIS is a Windows Service and needs to call through the QBXMLRP2EQODBCInteractive.exe DCOM. When qbcust.asp hangs without a error, it means something isn't right at the IIS end and the call to QODBC has been blocked by Windows. |
|
|
|
|
|
| Posted : 2008-10-08 09:30:59 |
| Great, I'll look into the IIS -> DCOM connection.
Thanks, Tom. |
|
|
|
|