hi expert
when we write a project that needs to connect to database for store data and.... we should attach the data base on end user computer who use Our Application
what things we need for attaching the data file? do we should install the microsoft sql server 2000 or sql server 2005 express edition? and we should attach the data base files manualy or we can attach them with some codes inside the application?
thanks

This depends on the application architecture.

If your application is a "client/server" database desktop application, then generally you would have a single database instance that all desktop applications connect to. In this case you need an attached and running instance of your database on a server running SQL Server.

If the application is designed around a "local" database, then each desktop running the application needs to have some flavor of SQL Server running. This could be SQL Server Express to which a database file is dynamically attached at run-time or any other configuration of SQL Server running locally that provides a live database.

There are many options, all of which depend on your application design.

-Peter

There is also SQL Server Compact edition, which doesn't require any install (unlike SQL Server Express).

/- Sam Judson : Wrox Technical Editor -/

SQL CE ? it is used for smart Device Application !!!!

It can be used on the desktop just fine as well (in fact I currently am doing just that on a project at work).

/- Sam Judson : Wrox Technical Editor -/