Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Oracle to QB connectivity - Error 80040408, Could not start QuickBooks.Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Oracle to QB connectivity - Error 80040408, Could not start QuickBooks. 
 Author   Message 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-12 11:19:45

I am trying to connect from Oracle server to Quickbooks on a remote  XP PC using Oracle's odbc gateway.  'qbodbc' is the tnsname in Oracle and it is similar to other working tnsnames settings, including one for MS SQL Server.  Below is a standard test using a dblink which fails due "80040408, Could not start QuickBooks."  I tried many different things, looked through you on-line tech notes, and can't resolve this issue. 

Thanks,

Julian

SQL> create public database link "qbodbcdblink" connect to
  2  "Admin" identified by "mypassword" using 'qbodbc';

Database link created.

SQL> select * from dual@qbodbcdblink;
select * from dual@qbodbcdblink
                   *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[QODBC] QB
Begin Session Failed. Error = 80040408, Could not start QuickBooks.
ORA-02063: preceding 2 lines from QBODBCDBLINK

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-13 18:19:52
Sorry, QODBC and QuickBooks need to be installed on the Oracle Server machine and you need a QODBC Server license to be setup as per: QODBC and Windows Service  

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-14 03:23:34

We are currently evaluating the QODBC Server vesion.  If it works for what we need it then certainly it will not be an issue to purchase the license.  It is on a an XP box right now, but our servers are on UNIX (Solaris).  Is there a solution that will work with Oracle on UNIX?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-14 17:15:07
No, you will need to use a application or program on the Windows XP box that talks to both QODBC (via ODBC) and Oracle (through the Qracle client). 

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-14 22:42:15
With my current configuration I actually have an Oracle product, a gateway for odbc, right on the XP box where QB and QODBC are installed, i.e. they are right next to each other.  The gateway architecture is such that you can access it from any Oracle database.  So ... you would think all the pieces are there.  What would trigger QB to be available to Oracle to eliminate this error: "Error = 80040408, Could not start QuickBooks."  Maybe there is something that can set for this to work?  Maybe at the Oracle end?
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-15 08:06:29
Please ensure the QODBC is working correctly first before trying to use Oracle as per: How do I connect to QuickBooks for the first time?  

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-15 11:36:42
I followed these steps when I initially installed QODBC and later when I checked more then once that QODBC is installed correctly.  VB demo testing worked, as does sourcing the data in Excel. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-15 11:55:42

The use of the QODBC Server Edition and the QODBC DCOMs is required by any application that is either a Windows Service or is called through a Windows Serivce. For example web pages run through IIS, which is a Windows Service. Even a VB program called by Windows Scheduled Tasks gets called as a service. The QODBC Desktop Edition is for applications that are run by a user on the computer desktop. 

There are a number of reasons for Error 80040408, Could not start QuickBooks > click here.

 

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-22 05:35:38

 I followed the recommendations in this thread, but I am unable to find a solution.  I also worked with Oralce to determine if the problem is that end.  It appears that everything is fine at the Oracle end.  I am including the content of a trace file - please scroll to the bottom for error 80040408.

Oracle Corporation --- TUESDAY JUL 15 2008 16:03:21.382

 

Heterogeneous Agent Release

11.1.0.6.0

 

 

 

Oracle Corporation --- TUESDAY JUL 15 2008 16:03:21.382

Version 11.1.0.6.0

Entered hgogprd

HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"

Entered hgosdip

setting HS_OPEN_CURSORS to default of 50

setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

setting HS_FDS_RECOVERY_PWD to default value

setting HS_FDS_TRANSACTION_LOG to default of "HS_TRANSACTION_LOG"

setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

setting HS_NLS_NCHAR to default of "AL16UTF16"

setting HS_FDS_TIMESTAMP_AS_DATE to default of "TRUE"

setting HS_RPC_FETCH_REBLOCKING to default of "ON"

setting HS_FDS_FETCH_ROWS to default of "100"

setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"

setting HS_FDS_MAP_NCHAR to default of "TRUE"

setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

setting HS_FDS_QUERY_DRIVER to default of "TRUE"

setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics"

Exiting hgosdip, rc=0

ORACLE_SID is "qbodbc"

Product-Info:

Port Rls/Upd:6/0 PrdStat:0

Agent:Oracle Database Gateway for ODBC

Facility:hsa Exiting hgogprd, rc=0

Entered hgoinit

HOCXU_COMP_CSET=1

HOCXU_DRV_CSET=178

HOCXU_DRV_NCHAR=2000

HOCXU_DB_CSET=31

HOCXU_SEM_VER=102000

Entered hgolofn at 2008/07/15-16:03:22

Exiting hgolofn, rc=0 at 2008/07/15-16:03:22

HOSGIP for "HS_OPEN_CURSORS" returned "50"

HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"

HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"

HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"

Exiting hgoinit, rc=0 at 2008/07/15-16:03:22

Entered hgolgon at 2008/07/15-16:03:22

reco:0, name:ADMIN, tflag:0

Entered hgosuec at 2008/07/15-16:03:22

Exiting hgosuec, rc=0 at 2008/07/15-16:03:22

HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"

HOSGIP for "HS_FDS_TRANSACTION_LOG" returned ""HS_TRANSACTION_LOG""

HOSGIP for "HS_FDS_TIMESTAMP_AS_DATE" returned "TRUE"

HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"

HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"

HOSGIP for "HS_FDS_RESULT_SET_SUPPORT" returned "FALSE"

HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"

HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"

using ADMIN as default value for "HS_FDS_DEFAULT_OWNER"

HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

Entered hgocont at 2008/07/15-16:03:23

HS_FDS_CONNECT_INFO = "qbodbc"

RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

Entered hgogenconstr at 2008/07/15-16:03:23

dsn:qbodbc, name:ADMIN

optn:

##>Connect Parameters (len=31)<##

## DSN=qbodbc;

#! UID=ADMIN;

#! PWD=*************

Exiting hgogenconstr, rc=0 at 2008/07/15-16:03:23

Entered hgopoer at 2008/07/15-16:03:24

hgopoer, line 159: got native error 0 and sqlstate IM006; message follows...

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks.

Exiting hgopoer, rc=0 at 2008/07/15-16:03:24

hgocont, line 1890: calling SqlDriverConnect got sqlstate IM006

Exiting hgocont, rc=28500 at 2008/07/15-16:03:24 with error ptr FILE:hgocont.c LINE:1910 ID:Something other than invalid authorization

Exiting hgolgon, rc=28500 at 2008/07/15-16:03:25 with error ptr FILE:hgolgon.c LINE:612 ID:Calling hgocont

Entered hgoexit at 2008/07/15-16:03:25

Exiting hgoexit, rc=0 at 2008/07/15-16:03:25

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-22 08:18:08
You will need to setup the QODBC Server Evaluation license as per: QODBC and Windows Service and unattended mode must work (as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? QuickBooks must also not be already running on the Windows XP computer when Oracle tries to connect. 

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-22 14:51:49
Unfortunately, I already went through all these steps more then once and I am unable to get it to work. 

  Top 
  julianqb 
  
 Group: Members 
 Posts: 8 
 Joined: 2008-07-12 
 Profile
 Posted : 2008-07-30 05:19:23

Is it possible to somehow extend the evaluation period for the server edition.  I would like to get about a week more so we can see whether we can resolve our current issue.  Thanks.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-07-30 08:13:08
You can continue to use QODBC even when it's expired with any of the sample QuickBooks Company files. Simply open a sample company file instead of your real one.  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to