how to save data in shared database file

Question

Hi frds I use mdf database file. In server side I keep mdf file in D drive. Now I share this mdf file via lan to client system. If Client add any data means it want to save in this shared .mdf file. For this how can I Proceed this and what is the connection string for this. Please reply me as soon as possible. Thank You

Mekalamani V · Answer

I want to share sql server database file between the computers how can i do this. Please reply me as soon as possible

Mekalamani V · Answer

I want to share sql server database file between the computers how can i do this. Please reply me as soon as possible

Nishant Mittal · Answer

Please refer this as well http://stackoverflow.com/questions/28699011/accessing-mdf-on-network-share-path

Mekalamani V · Answer

Thank You So much for Your Reply. I want to save save data in shared .mdf file. This mdf file located in network part in client side

Nishant Mittal · Answer

hi Try this add name=MyConnectionString connectionString=Server=.\SQLExpress;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Database=MyDatabaseForTesting;Trusted_Connection=Yes; />