opinion please

[simo sentissi]

Hello

I have been developping datadriven applications for a while now. I used sql
server and msde.
but I am on the hunt for an integrated database for a web application I want
to write: what I mean is I want to have a file based DB engine (if possible)
and include the file in a directory of the web app and access it. I just do
not want to deal with the install of a service when redistibuting the app.
I am considering ms access but I want to know if I could have multiple
connections to it via ado.net since the web app will have multiple users
hiting it. I guess that my first question.
the other one is :
Does any body know of an file integrated DB engine ? I am looking at
vistaDB and deseperatley looking for some xml based ones ?

 

[John Timney \(Microsoft MVP\)]

You will struggle with MS Access - once you start to load suers against it
it will fall over, and you'll get connection errors.

Take a look at single file database systems like Accuracer, you only hav to
buy a single licence and you can ship it as many times as you want. It also
supports ODBC so you could use it from ASP.NET.

http://www.aidaim.com/products/acr/accuracer.php

Never used it myself mind you, if its any good let me know......

--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>