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 = 80040408 using Remote Connector |
Author |
Message |
MMC |
|
Group | : Members |
Posts | : 1 |
Joined | : 2008-10-08 |
|
Profile |
|
Posted : 2008-10-08 09:15:18 |
We are receiving an error when we try to export to Quickbooks from within our application using the remote connector feature of QODBC. We are able to open/view the Quickbooks data using MS Excel and the VB test app so we know that the remote connector is setup correctly. The error seems to indicate that it is trying to open Quickbooks locally instead of using the remote connector. Do you have an idea what the problem may be from the error message/code snippet below?
We are using QODBC 8.00.00.242 on both workstations and Quickbooks Pro 2006
--------------------Error----------------------- Error 1429: OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. .. Called from: rctoqb Line number: 116 Program code causing error: Cnvflag ------------------------------------------------
Here are lines 114 - 116 from the rctoqb file referenced in the error:
*-- Create Connection for QuickBooks lcn_QBooks = CREATEOBJECT("ADODB.Connection") lcn_QBooks.OPEN ("DRIVER=QODBC Driver for Quickbooks;SERVER=QODBC;DFQ=.;OLE DB Services=-2;")
Thanks, Michael |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-08 10:40:31 |
Well your code snippet opens QODBC without using the Remote Connector parameters. This is a complete example using the QODBC Remote Connector in the connection string: -
DRIVER={QODBC Driver for QuickBooks};OptimizerDBFolder=C:\Program Files\QODBC Driver for QuickBooks\Optimizer;IBizRemotePWD=123456;IBizRemoteConnect=Yes;IBizRemoteURL=http://192.168.1.10:2080; IBizRemoteConnTimeOut=120;IBizRemotePromptForPWD=No;IBizRemoteForce2002_2003=Yes; OpenMode=M;DFQ=C:\QBOOKS\DW.QBW;OLE DB Service=-2
See: How do I build a connection string with all the available QODBC parameters? for further information.
|
|
|
|
|