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?
 Sausalito
 California - United States
 Wright Bass
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Quickbooks and QBFC8
Thread ID: 344593 Message ID: 345218 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Sunday, May 20, 2012 8:31:31 PM         
   


> >
> >
> > 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

Thanks Pete,

I logged into the server as "administrator" and it worked just fine, so it is a permissions issue. I will take a look at the permissions for that QB data folder and let you know what happens.

-Wright

ENTIRE THREAD

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