[digitalslacker]

I've just recently started having a problem with a custom web service that I wrote to add a Gift into RE via the API. This code was working and all my efforts to find out what's changed have been unsuccessful.
Error:

 System.Runtime.InteropServices.COMException (0x80040666): Path/File access error at
 Blackbaud.PIA.RE7.BBREAPI.CGiftClass.Save() at USNAWebservices.MasterService.addGift(String
 sConstitID, String sGiftType, String dTotalAmount, String dPaidAmount, String dtPaymentDate, String
 sCamp, String sFund, String sAppeal, String sPayment_Reference, String sPayment_Type, String
 sCardHolderName, String sCC_Num, String sCC_Exp, String sCC_Type, String sAuthCode, String sPay_plan,
 String iNumberOfPayments, String sAnonymous) 

What I know so far:
- The code was working in production for several months. I'm not sure when it broke but the first error was thrown last week.
- We have a development server that the same code is working on. While the environments aren't exactly the same they are very close.
- Our production server is running RE Enterprise but our Dev server is running a standard version of RE. I'm not sure if that's significant or not.
- In production our RE and BBNC database (where the webservice is) server are separate. On Dev they are all on the same box.

One item that i'm working but having trouble with is determining which instance of Blackbaud.PIA.RE7.BBREAPI.dll the API is trying to call. The error seems to indicate there is a Path/File access error. We have RE installed on the server where the web service is running and that DLL is in the PIA folder.

Any help would be appreciated! Thanks guys!

More info:
I put the code that was calling the API into a windows Application in VS and then put it on the server. It ran perfectly...so it seems to only be a problem when the API is called by a webservice....not sure if that turns on any light bulbs for anyone
thanks!

[JeffMon]

Hi Garrett,

Did you get this issue fixed? I know the error type is "Path/File access error", but did you get an explicit error message as well? Using FileMon from SysInternals (now part of M$) should help you identify which files are denying access. A few years ago when developing an RE Web integration I got the error message "Error saving record: The Microsoft Jet database engine cannot open the file 'C:\Program Files\Blackbaud\The Raisers Edge 7\SYSDB\re_sys7.mdb'." To resolve, I had to grant access to the ASP.NET Machine Account.

Jeff

[digitalslacker]

Quote:

Originally Posted by JeffMon

Hi Garrett,

Did you get this issue fixed? I know the error type is "Path/File access error", but did you get an explicit error message as well? Using FileMon from SysInternals (now part of M$) should help you identify which files are denying access. A few years ago when developing an RE Web integration I got the error message "Error saving record: The Microsoft Jet database engine cannot open the file 'C:\Program Files\Blackbaud\The Raisers Edge 7\SYSDB\re_sys7.mdb'." To resolve, I had to grant access to the ASP.NET Machine Account.

Jeff

Yes I did get it fixed. We do use FileMon and ProcMon for troubleshooting. Works great!
I fixed it a while ago and forgot how. I believe that the problem was that when we upgraded to v7.82 the framework swtiched over to .net 2.0 while BBNC was still on 4.1 in 1.1. I updated my refernce with the OLD 1.1 dll and I believe that corrected it.
I cant' be 100% sure at this point. Sorry I should have updated the thread when i corrected the problem.
I'll try harder next time!