Problems MS Access database files and ASP.NET 2.0

[Richard Finnigan]

Hi

I'm having real difficulties getting a very simple access database file to
show its data in visual studio data controls with various error messages
occuring. I've changed the permissions on the app_data folder for NETWORK
SERVICE.

Inserting a record seems to be particularly difficult though reading from an
Access database seems to be possible at the moment. I've done the obvious
things like using the Advanced SQL Generation options and putting in a
primary key field into the Access database table.

I've been using Visual Web Developer though I will soon be switching to
Visual Studio.

Is it actually advisable or possible to use MS Access database files in this
environment ?

Any useful advice would be gratefully recieved.

 

[Guest]

It is possible to use MS Access, but with SQLEXPRESS being a free download
and offering basically the entire SQL Server 2005 engine including CLR-hosted
assemblies and Reporting Services, I find it difficult to imagine scenarios
where it would make sense any longer. If what you need is a very simple,
lightweight, zero-install database, look into SQLite.
Peter

 

[Richard Finnigan]

It is possible to use MS Access, but with SQLEXPRESS being a free download
and offering basically the entire SQL Server 2005 engine including
CLR-hosted
assemblies and Reporting Services, I find it difficult to imagine
scenarios
where it would make sense any longer. If what you need is a very simple,
lightweight, zero-install database, look into SQLite.
Peter

Thanks for the advice RF

 

[Mike Lowery]

Thanks for the advice RF

If you're considering DB options, check out mySQL as well. Full blown DBMS
(unlike SQLite) and free:
http://www.mysql.com/

 

[Guest]

Mike,
With all respect, if somebody is using the .NET Platform and SQLExpress is
free, what rationale would they possibly have for MySql? Does it have
Reporting Services and FullText search? Can you write SQL CLR stored
procedures in it? Have you looked at some test scenarios as to relative query
performance with stored procedures?

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com