Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Wright Bass
  Where is Wright Bass?
 California - United States
 Wright Bass
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
Subject: RE: Quickbooks and QBFC8
Thread ID: 344593 Message ID: 345226 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Monday, May 21, 2012 1:03:09 AM         

> >
> >
> > Thanks for offering help. I'm trying to open a Quickbooks company file from within a FoxPro application and the QBFC8 DLL I am using to access QuickBooks generates the error. It does not matter whether QuickBooks is open or not. Here's the code:
> >
> >
> > ObjSession = CREATEOBJECT('QBFC8.QBSessionManager')
> > authflags = QBEXPDEF.qbver && "1" for SimpleStart, 2 for Pro, 3 for Premier, etc.
> >
> > ** Tell QBFC8 which version of QuickBooks to be accessed
> > ObjSession.QBAuthPreferences.PutAuthFlags(authflags)
> >
> > ** Company name (must match the Quickbooks company name) and application ID
> > ObjSession.OpenConnection("ASC Depot","DepotC")
> >
> > ** open QuickBooks company file
> > ObjSession.BeginSession("E:\INTUITDATA\ASCDEPOT.QBW", 2) && "2" = single or multi-user
> >
> > The last line is where I get the error. It is returned from the QBFC8 DLL to VFP. This code is located in a TRY-CATCH, where the CATCH section picks up the error message and displays it.
> >
> > I'm thinking it may be a rights issue but the users of my application are included in the Administrator's group. I am no Server2008/RDS expert.
> >
> > Any suggestions will be appreciated.
> >
> > Thanks,
> >
> > Wright
> Hi,
> Before we get into looking at the code the fact you mention a possible permissions issue is there anyway you could get the server administrator to temporarily add the Everyone Group to the folder where the QuickBooks data is stored with full control.
> Try to connect again and if thing work you know it is a permission issue if not let me know and we can review the code.
> Have the server administrator immediately remove the Everyone Group from the QuickBooks folder after testing as everyone on the network could access this folder if the Everyone group was left with full control.
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com


I set the permissions as you mentioned for a specific group. What finally fixed this was unchecking the "run as administrator" checkbox for my app. Works wonderfully in remote desktop sessions now. I'm learning more about Server 2008 but am surely no Admin yet.




Quickbooks and QBFC8 Posted by Wright Bass @ 5/11/2012 4:08:26 AM
RE: Quickbooks and QBFC8 Posted by Pete Sass @ 5/12/2012 2:48:32 PM
RE: Quickbooks and QBFC8 Posted by Wright Bass @ 5/12/2012 9:07:28 PM
RE: Quickbooks and QBFC8 Posted by Pete Sass @ 5/13/2012 1:37:22 AM
RE: Quickbooks and QBFC8 Posted by Wright Bass @ 5/20/2012 8:31:31 PM
RE: Quickbooks and QBFC8 Posted by Wright Bass @ 5/21/2012 1:03:09 AM