OLEDB exception on some machines

[jasco4617]

I am writing an application that runs as a service and utilizes the
..NET Framework v2.0. I am using an access database and OLE as my data
access driver.

On the machines I am developing this application on and my own personal
machine everything works fine. However, when I try and run the service
on any other machine I get a system.data.oledbexception thrown - thus
shutting the service down.

I have no clue why this is happening on some machines but not other. I
have checked and the same build of .net 2.0, MDAC, MS Jet, and MS
Office (includes access) are installed the various machines.

I have also tried installing the .NET 2.0 SDK to see if that solved the
issue and it did not.

Any help would be appreciated.

Thanks,
Patrick

 

[Guest]

Patrick,
Usually (but not always) this is caused by insufficient write permissions on
the folder that holds the Access MDB database file. Access creates temporary
files during normal operation, and if it can't write them, there goes the
whole house up in flames.
Ensure that the System or whatever account credentials the service runs
under has write permissions to that folder.
Peter

 

[jasco4617]

Peter,

I am running the service as Local System and it is resides in the
%systemroot%/KidPatrol folder.

I have another service that also runs from that same folder and with
the same account and it can access its database just fine.

- Patrick

 

[jasco4617]

Also, I changed the file extension to the database to .src would that
cause a problem?