External Removable storage,Data ,Sql Server

Posted by Raja_89 under ASP.NET on 3/10/2013 | Points: 10 | Views : 781 | Status : [Member] | Replies : 1
Hai
It is possible to use a sql database which is in removable disk and use that data in web application in asp.net C#


If yes explain with an example



Regards




Responses

Posted by: Raj.Trivedi on: 3/10/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hello Raja,

You cannot directly use the sql database which is USB because it will be .bak file and the bak file cannot be read in the web app.

The only thing is that you will have to store an .mdf file in USB and attach that in App_Data folder.

See this article.

http://www.dotnetfunda.com/articles/article2182-how-to-embed-sql-database-in-appdata-folder.aspx

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response