Can we access sqlserver database file (.mdf) from pendrive or cd.

Hi,
If you want to access your database file (.mdf) from CD or Pen Drive, you have yo attach your database with Sql server first.
To know how to attach database use link
Attach database
once your database is attached with Sql server, then you can easily access it using connection string.

Hello

Yes it is possible to do this thing, but one this you have to keep in mind is that the drive for that particular pendrive or CD must be same every time other wise it will show error during Connection.

yes--Possible (I'm assuming that client have .Net Framework installed and also SQL SERVER)

Write connection string in app.config file
By changing path of string in app.config you access that database.

Regards
Kul

u can do it without connection string .in place of connection string use the path of .mdf file

the client must have the sql server
and your when u create your .mdf file dont use pass
u can search in google for more tutorial

Here the thing we can access .mdf database file from any drive you want even from cd.
But if your accessing database from cd then your cd need to be "rewritable".
Because if its not then you can only access database but can't update database.

To access database from any drive just replace the drive letter in connection string with the drive letter where your database file (*.mdf) resides.

Example :

You cant use it by directly creating object

SqlConnection cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\dirname\databsename.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");


Or from app.config file : just put physical path of database