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 : QB in single user mode, but Report Grabber says sharing is happeningSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 QB in single user mode, but Report Grabber says sharing is happening 
 Author   Message 
  NHRunner 
  
 Group: Members 
 Posts: 1 
 Joined: 2006-07-24 
 Profile
 Posted : 2006-07-24 00:33:56

I just installed a demo but can't get at my QB data. See error message below

I'm using XP Pro SP2
Excel in Office 2003 SP2
QB Pro 2003 updated as of a few days ago. Is in Single user mode.
The only excel add-ins are:
Analysis Toolpak
Analysis Toolpak -VBA
Conditional Sum Wizard
Intenet Assist VBA
QreportGrabber

===========================
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040422, This application requires Single User file access mode and there is already another application sharing data with this QuickBooks company data file.
Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"

2006-07-23 09:48:52 QODBC Ver:  5.00.00.104

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-07-24 08:40:00

Error #80040422 is saying, "This application requires Single User file access mode and there is already another application sharing data with this QuickBooks company data file." This could even be caused by your application having a active connection already.

A good example is when I use MS Access and link a QODBC table and then run a QODBC pass-though query on another table (that's not linked) I will get the message even through I am just running QuickBooks on my Windows XP Notebook. I get the error because at that point of time there are two concurrent connections and my complany file is in Single User mode.

The answer is that the Company file should be by default in multi-user mode always unless you are deleting records.

You can also specify the OpenMode setting in your connection string. See: How do I build a connection string with all the available QODBC parameters? for more.

As far as QReportGrabber support is concerned, please contact AccountiGrate directly on 888-302-8928 or sales@accountigrate.com for further support as the developer is now selling and supporting the product directly.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to