This is a known problem that exists in the QuickBooks qbXML SDK from Intuit, caused by QuickBooks when upgrading an existing QuickBooks company file to the new 2006 (or 2007) USA format, creating a new company file, or even adding new user accounts to QuickBooks.

The original QuickBooks work-around for this issue was provided by Peter Vogel at Intuit however I have added the additional elements regarding QuickBooks user accounts and screen dumps to make things clearer - please contact him should you have ongoing issues involving this bug in QuickBooks USA editions 2006 and greater.

IMPORTANT UPDATE: Intuit Engineering is currently attempting to drill to the root cause of this problem. We believe the target is to have a fix for QB2008R3 (that's USA editions of QuickBooks 2008 Release 3, sooner if the problem is identified sooner).

NOTE: These instructions require you to use the "Admin" QuickBooks Admin account, you can't use a QuickBooks user acccount.

In the meantime, here is the best workaround for the problem :-

1. Make a backup using QuickBooks and then close QuickBooks
2. Browse to the folder where the .QBW file is stored.
3. Create a folder named "backup"
4. Select all files EXCEPT the .QBW file that have the same name as the .QBW file (i.e if the file is foo.QBW then select foo.QBW.TLG, foo.lgb, etc.)
5. MOVE the selected files to the backup folder you created in step 3.
6. Start QuickBooks
7. Open your company file, using the "File" menu, "Switch to Single-User Mode" (if you're running your company file in multi-user mode).
   Remove all QuickBooks user accounts for the company file (if you have setup users) 
8. Edit/Preferences/Integrated applications...
9. Remove all "Flexquarters QODBC" records
   Re-add your QuickBooks user accounts for the company file (if you have setup users)  
10. Close the preferences dialogs
11. Connect QODBC using VB Demo, do NOT specify unattended mode. When QODBC starts, QuickBooks will ask you permission for this driver to access your QuickBooks data. Check the "Allow this application to access NI or Social Security Numbers, customer credit card information, and other personal data" options and answer "Yes, Always” to this and the QODBC driver is added to the Integrated Application list.

    

    If you're using QuickBooks 2006 or 2007 in multi-user mode, you can also select the user account QODBC could use, but for unattended mode you must select QuickBooks "Admin" account:-

    

    Confirm that you want to allow this access by clicking on "Yes". This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop.

     

12. Close all applications using QODBC and make sure all the connections are closed. Using the QODBC Setup Screen General Tab, check the Locate a company file: option. This allows you to setup the full path to where your QuickBooks data file resides. For example: “C:\Program Files\Intuit\QuickBooks Pro\Myapp.qbw”.

    

    The [Browse] button will let you choose your QuickBooks company file from the folder it is in.

    

    To use the QODBC auto-login unattended mode you must specifiy the full path of the QuickBooks company file you wish to connect to.

    

    The Advanced tab in QODBC Setup v6 Build 148 and later now has new defaults for Integrated Application Defaults Authorization popup settings. These settings are only available to USA QuickBooks 2005, 2006 and USA QuickBooks 2007 users, otherwise they are greyed out. Use these settings to allow "auto-login" with or without a visible QuickBooks User Interface.

    

     

13. Using the QuickBooks menu, select Edit/Preferences/Integrated applications and check that you have to authorized QODBC to login to QuickBooks automatically. To do this you must start QuickBooks as the Administrator. Go to the "Edit-Preferences" menu item in QuickBooks. Then select the "Integrated Applications" icon from the left side.

    

14. Find your app, choose properties... and set/check unattended mode up for the user "admin". Then highlight one application (usually FLEXquarters QODBC) and press the "Properties" button and click on the Company tab. Check the "Allow this application to access this company file".

    

    And check the "Allow this application to login automatically" and select a user from the "Login As" drop down. You will need to repeat this for all the applications on the list that you use.

    You should also check the "Show Reminders List when opening a Company file" preference is unchecked.

    

     

15. Close preferences

16. Close QuickBooks

17. Run the application in unattended mode 

If Unattended mode still does not work  
Remove the QODBC integrated application entries from the original QuickBooks 2003/2004/2005 company file, then allow QuickBooks 2006 (or 2007) to upgrade the company file to the new format and then have your applications connect the company files with QuickBooks and the company file open to set up the integrated application options again.

The Advanced tab in QODBC Setup v6 Build 148 and later now has new defaults for Integrated Application Defaults Authorization popup settings. These settings are only available to USA QuickBooks 2005 and USA QuickBooks 2006 users, otherwise they are greyed out. Use these settings to allow "auto-login" with or without a visable QuickBooks User Interface.

Some USA users may also find that auto-login doesn't work when they updated to QODBC v6.00.00.150 (or higher). To rectify this, simply follow the 17 step procedure outlined above in the original post.

See: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? for more information.

We're sorry, but as stated clearly at the start ot this topic, this is a known problem that exists in the QuickBooks qbXML SDK from Intuit, caused by QuickBooks when upgrading an existing QuickBooks company file to the new 2006 USA format, upgrading to QODBC 6.00.00.150 or higher from a earlier 6 build, or even adding new user accounts to QuickBooks. It not only affects QODBC but all integrated applications users and SDK developers in USA.

While I appreciate your frustration, your opinions might be better voiced to your QuickBooks Account Representative.

To All trying to get this to work: SUCCESS - TRY THIS

I follow all of the steps outlined here, several times, it didn't work.  I even moved my company file to another location, by itself, it didn't work.  I was ready to throw my computer out the window, it still didn't work.  Reading this and another chain on this support group made me more frustrated than ever as the answer of "it's not our fault" doesn't sit well when you are trying to decide to purchase something.  I would suggest you add a step 6a, per below to your original post.

I repeated STEPS 1 to 6

6a (New Step) Removed all users and add them back into quickbooks.

Continued with steps 7 to 17, and !!!! it worked

QB USA 2006 Premier Retail - Upgraded from 2005

QODBC v7.00.00.207 (trial mode)

Unattended mode works for me!  - But, when it auto-logs in I get 5 or 6 pop-up windows real quick from quickbooks (not running),

they look like reminders or something.  Any thoughts?

You can switch off the Reminder list in Preferences:

I created two new company files in QBES 7.0 r8 and the auto login unattended mode does NOT work.  I.e., this issue does not solely relate to company files upgraded from earlier versions.   Any thoughts?  Any word from Intuit whether this issue is being actively addressed?

I agree.  Its not funny.  The 17 Step process does not work.  I've emailed everyone I can think of at Intuit, including Agus Thomson trying to express concern and get help.

Any other suggestions?  What do we do?  I'm trying to set up F9 (kind of like a Crystal Reports sandbox -- but much easier) that needs to extract data via DSN into a datamart.  I can't make that work without auto-login functioning properly.

Try copying the company file name.qbw file to a new directory folder and do the procedure again (without the backup stuff).

IMPORTANT UPDATE: Intuit Engineering is currently attempting to drill to the root cause of this problem. We believe the target is to have a fix for QB2008R3 (that's USA editions of QuickBooks 2008 Release 3, sooner if the problem is identified sooner).

The staff at Intuit QBES (QuickBooks Enterprise Solutions) would like me to pass the following message to you:

Using the R5 release for Quickbooks Enterprise Solutions Version 2008, developers can now use their QODBC applications with Quickbooks closed. 

Download the R5 update here:
http://support.quickbooks.intuit.com/Support/ProductUpdates.aspx

Remember that when using this feature, you have to use 'Locate a company file' or a QODBC connection string with "DFQ=C:\Program Files\QODBC Driver for QuickBooks\sample04.qbw" rather than 'Use the company file that's now open in Quickbooks'.

Note: R5 for QuickBooks 2008 has the fix, not R11 for QuickBooks 2007 !!!!

We are using Quickbooks Pro 2006 and I've tried to follow the 17 steps.  My issue is when I get to step 6.  Once I move the other files and then try to open the .qbw file it gives me an error message that I can't open the file. 

Note: R5 (and later) for QuickBooks 2008 has the fix, not R11 (or later) for QuickBooks 2007 or 2006 !!!!

The [Browse] button will let you choose your QuickBooks company file from the folder it is in.

To use the QODBC auto-login unattended mode you must specifiy the full path of the QuickBooks company file you wish to connect to.

I just talked to Intuit to further troubleshoot my issue.  I also worked worked with Oracle to trace their odbc calls and everything is okay from that side (trace log content included in the other thread).  On the call with Intuit we tried to step through the 17 steps list.  However, I can not execute the recommendation under step 14.  Everything is grey, including a blank line, except the top line.  

I look forward to your support as soon as possible.

Thank you.

The Advanced tab in QODBC Setup v6 Build 148 and later now has new defaults for Integrated Application Defaults Authorization popup settings. These settings are only available to USA QuickBooks 2005, 2006, 2007, 2008 and UK, Canada, Australia QuickBooks 2008 (2008/09) users, otherwise they are greyed out. Use these settings to allow "auto-login" with or without a visible QuickBooks User Interface.

Please confirm - this issue is fixed in 2008 R5 but not in 2007 R11?

Regards,

Jason

OKAY!!! THANKS FOR YOUR REPLY!!!  HAVE WONDERFUL DAY OR WHATEVER THE HECK IT IS DOWN UNDER!!!

HI,

I  understand that the issue is solved with R5 for QuickBooks 2008. But how about AuickBooks 2009, is this issue completly solved or should we have another Release?

Thanks

Sami

Thanks Tom for your reply. Since I'm using USA version, I'm all set.

Sami