File name maybe incorrect on database path?

Question

Hi Team   Please help me to understand this error, the web config has the following connectionString. What does this error mean? Do i have to change the path..?          "eNtsaOnlineRegistrationDB"  connectionString =  "Data Source=GcobaniM-L\SQLEXPRESS;AttachDbFilename=[DataDirectory]\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistration; Integrated Security=True"  providerName= "System.Data.SqlClient" />

Amit Mohanty · Answer

Hey if you have the .mdf file in App_data folder then try below connection string
add   name  =  "eNtsaOnlineRegistrationDB"  connectionString =  "Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistration; Integrated Security=True"  providerName= "System.Data.SqlClient" />

Guest User · Answer

No Amit   My question i think is, the folder App_Data had already has the file inside.mdf. See my screen shot, why began to ask below question for that reason. Or am i again misunderstood you well?

Amit Mohanty · Answer

Hey you have already App_Data folder under your project. No need to create AspNet--AppData folders.   Copy the .mdf file and paste it to App_Data folder

Guest User · Answer

Ok i have done that so far, must the app_data have..mdf inside?

Amit Mohanty · Answer

Click on Solution Explore -- right click on project name -- add -- add asp.net folder -- app_data

Guest User · Answer

I dont follow Amit   The path does exist on the project folder on my Visual Studio, where else could i have to create it? I dont understand mate. Show me an example(default, the path as to say).

Amit Mohanty · Answer

Yes you have to create that folder if it is not there.

Guest User · Answer

Rajesh   I have followed the link, as per sent below. Now i am getting this exception that it exists. The MSSQ Server is changed to local account now. What else do i need to change?

Jignesh Kumar · Answer

Hi,   You need to replace [] sign with ||, Please find below link, https://www.connectionstrings.com/sqlconnection/attach-a-database-file-located-in-the-data-directory-on-connect-to-a-local-sql-server-express-instance/

Rajeesh Menoth · Answer

Hi,   Please check the following similar thread :   https://stackoverflow.com/questions/6703368/sp-attach-single-file-db-error-failed-with-the-operating-system-error-5access