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 Open Connection Failed |
Author |
Message |
|
Posted : 2006-07-19 03:00:50 |
When trying to connect to QODBC Server Version, I get the following error:
IsAService: True Open Connection Failed. S0000 00000 [QODBC] QB Open Connection Failed. Create DCOM Instance Error = 8000401a, Unknown error.. Created qbXMLRP2 OK. SDK Module: QBXMLRP2EQODBCInteractive.exe
Below is a summary of our circumstance. Hopefully you will be able to provide some information that will help...
- QODBC, Quickbooks, Coldfusion, and SQL Server are installed on the same Windows 2003 Server, 64-bit Edition
- I followed directions to set up the Web Server Edition using DCOM, found here: http://www.qodbc.com/qodbcweb.htm
- The "Test Connection to Quickbooks" button as well as the VB test are functioning properly.
- I attempted to use the Automatic DCOM Configuration tool, and nothing happened. No error, no results. The Command Prompt window appears for a fraction of a second, then disappears. Feeling optimistic, I ran the included VBS script, which also didn't work. (By the way you may want to update that script to accomodate searching a 64-bit registry and its Wow6432Node subtree - I got an error when the script went searching for the install directory. After modifying the script to find the key, I get an error saying it can't create "DCOMPerm.")
- Since the automated tool failed I followed manual config instructions (http://www.qodbc.com/QODBCWebManualDCOMXPPro.htm) and have verified that the settings reflect those found in the linked document.
- I followed instructions to use SQL Server Management Studio in tests (http://www.qodbc.com/qodbcsqlserver.htm) as well as configure our Coldfusion Server (http://www.qodbc.com/QODBCWebColdFusion.htm) and received the same error in each of these clients.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-19 09:20:43 |
|
|
|
|
Posted : 2006-07-19 10:24:52 |
Thanks for the reply, Tom.
As I mentioned in my original post, I already followed the instructions for manually setting up DCOM, to no avail. Since the error is returned by both SQL Server management tools and Coldfusion, the second link you provided probably won't solve it, either.
The sample CFM file provided fails for qbXMLRP2eInteractive.exe, which certainly is the cause for the SQL error string I reported. Yet I have followed the directions - and confirmed the proper settings twice - in the post you referenced "How do I manually setup the QODBC DCOM..."
Can you provide any alternate course to help narrow down what I may be doing wrong?
Thanks
paul |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-19 10:59:07 |
|
|
|
|
Posted : 2006-07-20 02:17:47 |
Tom,
Yes I rebooted to no avail. Yes, auto-login seems to be working fine.
No, the simple IIS connection is working; the error I posted below were returned by both the SQL client and Coldfusion (i.e, a web browser).
Since the testDCOM.cfm fie fails both of the .exe lines, I am sure the issue is with qbXMLRP2eInteractive.exe. Accordingly I have checked and rechecked the instructions in "How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server?" and am confident that they are set according to those instructions. Under what circumstance might the included instructions not be sufficient?
-Paul |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-20 08:33:02 |
If qbcust.asp works ok, then you have a security issue with the system account used by both the SQL client and ColdFusion. This account needs to have all rights to the QODBC folder and the QODBC DCOM servers. |
|
|
|
|
Posted : 2006-07-20 08:43:42 |
Tom, I decided to abandon ship on the DCOM method and switch to Remote Connect. Things seem fine using this method. Thanks for your time. |
|
|
|
|