I keep getting this error when running a Stored Procedure and trying to save it directly to a DataSet (VB.Net).  I've also tried using a DataReader, still no luck:

[QODBC] Error: 3301 - Cannot perform this request unless an interactive QuickBooks user is logged in.

If I change my command to a simple SELECT statement, everything works fine.  It seems one cannot run a stored procedure (e.g. sp_profitandloss) without launching the QB UI.  Why, and is there a workaround?

I have a customer that has dozens of QB files that need to have a report run, and opening and closing each file one at a time is painfully slow.

Interesting, could you please try using VB Demo and advise the results? A sp_report will minic an interactive report if you use the: DisplayReport='Yes', option so please make sure you're not using it and delete the parameter if you are.

sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of"
parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly', DisplayReport='Yes'

Ah, yes, I was using that parameter (copied it from some sample code).  I removed it and that worked!

However, I have another related problem with a different company file.  Even though FLEXquarters QODBC is listed in the Company Preferences with access to the company file, I still get this error:

ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041d, This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login through the Integrated Application preferences.

I've removed FLEXquarters QODBC from the Company Preference, closed QB, reopened the file directly in QB, reran my program, was given the alert to set the company preference, allowed it (Yes, always, even if QB is not running).

I do not have any users in this company file, other than the built in Admin.  There used to be a password for the Admin and I've since removed it (blank).  I can open other files just fine (once the Company Preference is set).

My connection string:

Troubleshooting auto-login is covered in depth in: After upgrading to QuickBooks 2006 or 2007, QODBC "auto-login" unattended mode no longer works? 

You might need to go back to using a DSN instead of a DSNless connection string. See: How do I build a connection string with all the available QODBC parameters? for more.

The "17 steps" fixed it (although I only had to do steps 1 thru 11).  I would have tried it earlier, but I didn't think it would apply to me because:

1.  I've never had users setup
2.  I've been using QB 2006 for at least 2 years now, but just got QODBC about a month ago, so I didn't have QODBC before I upgraded to QB 2006 (which seems to be the core issue that this resolves).

My client is an Accountant and has anywhere from 50-200 QB files...creating a DSN for each is not feasible, so I will have to continue to use the DSN-less approach.

Everything seems to be working wonderfully now!