Help connecting to Access DB from web service

I am creating a web service that returns data from an Access 2000 database
using VS2005. The Access database is located on a different server than
where the web service is running. The Access database is also opened by a
different desktop application running on various workstations on the
network.



While developing / debugging the web service is hosted on my development
machine using the 'ASP.NET Development Server' that is included with VS2005.
When deployed it is being host with IIS.



I am using the following connection string:



Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\slo-science1\data\PBI Chem
data\PBIChemDatabase.mdb"



If the database has NOT opened by any of the workstations running the
desktop application then the web service runs correctly on both my
development machine as well as on the IIS server.



If the database has been opened by any of the workstations running the
desktop application the web service runs correctly ONLY on my development
machine and fails on IIS with the following error:



System.Data.OleDb.OleDbException: Could not use ''; file already in use.



What are the differences between the 'ASP.NET Development Server' and IIS
that would effect how a web service opens a remote Access database?



Does anyone know how what settings can be changed so that the web service
runs correctly on IIS?



Thanks in advance,
Jeff Richardson


.

Relevant Pages

  • Re: IIS Hosting Webservice which accesses a COM server
    ... I've create a COM server in VFP which I try to access from a Webservice ... If you want to run executables on IIS from a script (i.e. an ASP, ASP.Net, ... well as Web Service Extension for the appropriate Script Engine. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Run IIS in a domain user context
    ... > If this is IIS 6.0, you need to change the identity of the Web Application ... When I say local machine I mean the server that is hosting IIS ... server side in the context of LocalSystem which I assume the web service ...
    (microsoft.public.inetserver.iis.security)
  • Re: interprocess comms in local network
    ... Server needs to be an application with buttons and menus as it will need to ... I also need to set up permissioning such that only clients that I've ... > ASP.NET provides support for implementing a web service. ... > If IIS was installed when you installed the .NET Framework, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: IIS 6.0 quits responding
    ... Your setup for Windows Server 2003 sounds fine. ... have no idea how SNMP is able to tell that IIS is not working. ... The SNMP Monitoring on another server is showing that Web Service is not ...
    (microsoft.public.inetserver.iis)
  • Re: Calling a Web Service?
    ... the Business will not allow the AIX server to be on the ... So my issue remains how do I call a web service when I can't see IIS? ... you wrote some sort of proxy, how would the AIX box know how to access it? ...
    (microsoft.public.dotnet.framework.webservices)