QODBC not allowed to logon automatically to Quickbooks 2008 |
Author |
Message |
|
Posted : 2008-02-01 05:41:23 |
We recently upgraded to Quickbooks Enterprise v. 8.0, and now if we try to access Quickbooks data through QODBC when Quickbooks is closed, the following message appears: "Error = 8004041d, This application is not allowed to log into this QuickBooks company data file automatically..."
However, in the Integrated Application preferences, we checked that the app is already set to be allowed automatic access. The queries run fine if QuickBooks is open.
Has anyone else encountered this issue? What can be done? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-01 08:20:21 |
|
|
|
|
Posted : 2008-02-07 11:07:18 |
I went through the process again to get unattended mode to function, but I had the following results:
- Set up unattended mode for VBDemo and SQL Server and it worked fine. - Logged out, logged back in, SQL Server still worked fine. - Opened QODBC control panel to try "Load Updated Data" under Optimizer menu. Obviously failed because the app was not given permission to access data yet. - Opened Quickbooks, used "Test Connection to QuickBooks" button to give the QODBC panel permission to auto login. - Closed QuickBooks, then tried "Test Connection..." again, but this time it failed with the error mentioned in the above post. - Unattended mode now is not working again for any app!!!
Please help! Unattended mode seems to have been rendered useless for me since each time I go through the steps to fix it, something causes it to fail again. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-07 12:33:10 |
Don't use the "Test Connection to QuickBooks" option as this function attempts a connection in a special way. Use VB Demo to first connect and:-
sp_optimizeupdatesync All
to do a "all tables" update sync. |
|
|
|
|
Posted : 2008-02-08 03:43:37 |
The same thing as before happened when I tried to run QODBCUPD.EXE. I gave it permission, then unattended mode stopped working on all applications.
Does this mean running sp_optimizeupdatesync All is the only way to run the update data procedure? I would like to schedule this as a task to run each night. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-08 07:45:28 |
|
|
|
|
Posted : 2008-02-14 10:18:54 |
Some of the queries that I run as part of integrations packages do not seem to activate the optimizer when run. For example: SELECT InvoiceLinkedTxn.RefNumber, InvoiceLinkedTxn.LinkedTxnTxnType, InvoiceLinkedTxn.LinkedTxnTxnDate, InvoiceLinkedTxn.LinkedTxnAmount, InvoiceLinkedTxn.CustomerRefFullName FROM InvoiceLinkedTxn NOSYNC I ran sp_optimizeupdatesync on the table and the optimizer updated the Invoice table, and then I had more rows returned when I re-ran the query.
I am using NOSYNC on all my queries, but why do some activate the optimizer and others don't? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-14 11:13:53 |
NOSYNC means don't resync with QuickBooks, so if you use the NOSYNC tag it will not run a resync operation for that query, however, when you update QODBC all the installation defaults get reinstated.
To work correctly you must first check that you are running QODBC v8.0.0.240 or higher (see: How can I get the latest version of QODBC? ) and then change your optimization settings to use the The start of every new connection (with "Load Updated Data" first) option and confirm that the Multi-Table Sync option has been disabled. If not, uncheck the Multi-Table Sync option as this is often defaulted on (checked) with QuickBooks Enterprise and the QODBC Enterprise Desktop Edition.
|
|
|
|
|
Posted : 2008-02-20 07:12:12 |
All the options are set as you listed, and I am already running the latest version of QODBC. When I run the following query, the optimizer does not activate at all and the query takes a long time to run (~2,000 records): SELECT Customer.Name, Customer.FullName, Customer.IsActive, Customer.ParentRefFullName, Customer.CustomerTypeRefFullName, Customer.SalesRepRefFullName, Customer.Balance, Customer.JobStatus FROM Customer WHERE (Customer.Sublevel=1) ORDER BY Customer.Name
If I run the same query with NOSYNC, the query is very fast since it uses the optimizer data, but the optimizer still does not run its update data routine beforehand, so I still don't get the latest data.
However, running the following query (without NOSYNC), the optimizer does run beforehand and get the latest data, and it finishes in no time (~74,000 records): SELECT TimeTracking.TxnDate, TimeTracking.CustomerRefFullName, TimeTracking.EntityRefFullName, TimeTracking.ItemServiceRefFullName, TimeTracking.PayrollItemWageRefFullName, TimeTracking.ClassRefFullName, TimeTracking.DurationMinutes FROM TimeTracking |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-20 07:21:31 |
To force a resync of the customer table first, do:
SELECT Customer.Name, Customer.FullName, Customer.IsActive, Customer.ParentRefFullName, Customer.CustomerTypeRefFullName, Customer.SalesRepRefFullName, Customer.Balance, Customer.JobStatus FROM Customer verify WHERE (Customer.Sublevel=1) ORDER BY Customer.Sublevel, Customer.Name |
|
|
|
John |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-07-04 |
|
Profile |
|
Posted : 2008-03-08 09:23:40 |
I am running a Java application that is using QODBC to connect to Quickbooks to update timesheet data. We recently upgraded to Quickbooks 2008 and upgraded the driver as well to version 8. We were initially able to get the driver to connect to Quickbooks automatically while the application is not running, and it has worked fine for the past couple weeks. I recently had to make a change to the program and create a new build file. I have not been able to get the Java application to run automatically without Quickbooks running as before. I keep getting the same error:
"Error = 8004041d, This application is not allowed to log into this QuickBooks company data file automatically..."
The Java appication will work when the admin user logs into Quickbooks and grants permission to the Flexquarters driver when the Java application is run. But we do not want to do this all the time. I have run through the procedure to test the driver and the connection to the VB Demo application.
I see the proposed solution below, After upgrading to QuickBooks 2006 or 2007, QODBC "auto-login" unattended mode no longer works? but deleting all our users and recreating them seems like an excessive amount of work to solve this problem.
I also see below the proposed solution to run: sp_optimizeupdatesync All. Is this related to the same issue? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-11 12:03:01 |
Granting permission to the FLEXquarters driver (QODBC) is a one off procedure for a given application and company file. Not to sure why you need to do this over and over again. Both permissions and unattended mode setup is unique to the company file (not QuickBooks), so if you set these things up and then copy in the company file from yesterday, then you have to start the setup again from scratch.
In existing company files, if you add a QuickBooks user you can get the deaded ""Error = 8004041d, This application is not allowed to log into this QuickBooks company data file automatically..." error again and you will need to delete all QuickBooks users, remove the FLEXquarters QODBC Driver from QuickBooks Integrated Application options, and setup the company file again from scratch, yet again.
|
|
|
|
John |
|
Group | : Members |
Posts | : 5 |
Joined | : 2007-07-04 |
|
Profile |
|
Posted : 2008-03-12 03:14:36 |
So what you're saying is that the error 8004041d can be caused by adding a new user to an existing Quickbooks company file? When you say "Add a Quickbooks user" are you talking about any user or a user specifically added to connect through the integration application? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-12 11:19:25 |
This is an Intuit bug that can bite in lots of ways, either way can trigger it. |
|
|
|