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" />

Amit Mohanty · Answer

Hey, the declaration of AttachDbFilename is wrong. Use this AttachDbFilename = |DataDirectory| \eNtsaOnlineRegistrationDB.mdf;

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

Guest User · Answer

Hi Amit After the amends from the path, Question is does that directory needs to be created? Its not there, how do i pass this if not, please see the attaced screen shot.

Guest User · Answer

[HttpPost] [AllowAnonymous] [ValidateAntiForgeryToken] public async Task Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser() { UserName = model.UserName }; user.Email = model.Email; user.ConfirmedEmail = false ; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { System.Net.Mail.MailMessage m = new System.Net.Mail.MailMessage( new System.Net.Mail.MailAddress( "ggcobani@gmail.com" , "Web Registration" ), new System.Net.Mail.MailAddress(user.Email)); m.Subject = "Email confirmation" ; m.Body = string.Format( "Dear {0} Thank you for your registration, please click on the below link to complete your registration: {1} " , user.UserName, Url.Action( "ConfirmEmail" , "Account" , new { Token = user.Id, Email = user.Email }, Request.Url.Scheme)); m.IsBodyHtml = true ; System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient( "smtp.mydomain.com" ); smtp.Credentials = new System.Net.NetworkCredential( "ggcobani@gmail.com" , "password" ); smtp.EnableSsl = true ; smtp.Send(m); return RedirectToAction( "Confirm" , "Account" , new { Email = user.Email }); } else { AddErrors(result); } } // If we got this far, something failed, redisplay form return View(model); }

File name maybe incorrect on database path?

Answers (13)