Re: Help connecting to Access DB from web service
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 05 Apr 2006 13:23:14 -0400
Gotcha -- Jet can be a lot more flexible as long as you don't care
about security and work around its inherent fragility. It looks like
Paul has given you the answer to your question. Just out of curiosity,
what is the functionality that you can't duplicate?
--Mary
On Mon, 3 Apr 2006 09:39:12 -0700, "Jeff Richardson"
<BobcatRidge@xxxxxxxxxxxxxxxxx> wrote:
Hi Mary,.
Thank you for your reply.
The compelling reason is that the desktop application, mentioned below, is a
commercial application that uses the Access db as its native file format. I
can not abandon the commercial application because it provides functionality
that I have not been able to duplicate myself.
Are you aware of a work-around form my file locking problems while running
under IIS?
Thanks in advance,
Jeff.
"Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:q9rv22lc66r6o7pp6ok3mpsn68qll76h5n@xxxxxxxxxx
Is there a reason why you can't use SQL Express? Jet is totally
unsuited as the data store for an ASP.NET application. If you persist,
you are always going to have headaches. One of the reasons is locking,
as you have discovered. It's not hard to Import Jet data to Express,
and Express is free, so there is no compelling reason not to use it.
--Mary
On Fri, 31 Mar 2006 17:13:37 -0800, "Jeff Richardson"
<BobcatRidge@xxxxxxxxxxxxxxxxx> wrote:
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
- References:
- Help connecting to Access DB from web service
- From: Jeff Richardson
- Re: Help connecting to Access DB from web service
- From: Mary Chipman [MSFT]
- Re: Help connecting to Access DB from web service
- From: Jeff Richardson
- Help connecting to Access DB from web service
- Prev by Date: Re: Data Access Problem
- Next by Date: Re: merging app.config files
- Previous by thread: Re: Help connecting to Access DB from web service
- Next by thread: Re: Help connecting to Access DB from web service
- Index(es):
Relevant Pages
|
