|
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
|
|
| Problems with QODBC & ColdFusion |
| Author |
Message |
| Jim |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-01-23 |
|
| Profile |
|
| Posted : 2007-01-23 08:57:29 |
|
I am trying to install QODBC to work with Cold Fusion and I am having problems. Here are the specs of my server:
Windows Server 2003
QuickBooks Enterprise Edition 6.0
Cold Fusion MX 7.0.2
When I go to the test page TestDCom.cfm here are the results I get:
QODBC ColdFusion DCOM Access Test Page
| QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
| • |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
Success |
| • |
• |
|
|
|
• |
QBXMLRP.dll |
Success |
| |
|
• |
• |
• |
|
QBXMLRP2EQODBCInteractive.exe |
Success |
| |
|
• |
• |
|
• |
QBXMLRP2.dll |
Success |
| • |
• |
• |
• |
|
• |
XERCES-COM.dll |
Success |
|
If I go to DisplaySQL.cfm here is what it says:
Error Executing Database Query.
|
| [Macromedia][SequeLink JDBC Driver][ODBC Socket][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. |
I have QB running with my file open.
In the DSN settings I checked the box that says use the open file and under the web servers tab I checked the box that says to use DCOM servers. I have tried a few things and cannot get it right. Sometimes instead of that error there is a DCOM error but I dont remember what it says. Any ideas?
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-23 09:41:48 |
|
|
|
| Jim |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-01-23 |
|
| Profile |
|
| Posted : 2007-01-24 04:02:31 |
I went through those pages and everything seemed right except for my problem below. Also I tried doing that workaround for 2006 and had no luck.
The proble I had is in Cold Fusion Administrator when I click "Verify all Connections" here is what it says for the "QBs" datasource:
| |
QBs |
ODBC Socket |
Error |
Connection verification failed for data source: QBs
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][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.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][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. |
Before trying that I have QuickBooks open and my company file open.
|
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-24 08:17:05 |
QuickBooks needs to be closed and if unattended mode is correctly configured, QODBC will launch QuickBooks in background mode and open the company file specified in the QODBC Setup Screen. Note: You must specify the company file with it's full path:
In other words, close QuickBooks and then connect to QuickBooks Data using VB Demo. You should be able to read the customer table without seeing QuickBooks running on your desktop.
See also: After upgrading to QuickBooks 2006, QODBC "auto-login" unattended mode no longer works? |
|
|
|
| Jim |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-01-23 |
|
| Profile |
|
| Posted : 2007-01-26 08:46:23 |
It took a little messing around and I dont know what step did it but it is working now. Thank you for your help.
Jim |
|
|
|
|