Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

connect to .mdf

I'm running Visual Studio 2013 and upgraded for local db to SQLExpress 2014 ver12.

Everytime I try and access a .mdf I get the enclosed error now:

It's like it's tying to find my previous installed express version? How do I switch it in VS2013 to find the correct version of the db?
0
thenrich
Asked:
thenrich
  • 2
  • 2
1 Solution
 
Utkarsh KulkarniSr. Sw EngCommented:
It seems like file path issue.
The SQL server installation folder is different for 2005/2008/2014 express editions.
Default path for SQL 2008 R2 is like "C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA"

Change this to Path to 2014 version folder and it will access the .mdf file.
0
 
thenrichAuthor Commented:
Where do I adjust the path?
0
 
Utkarsh KulkarniSr. Sw EngCommented:
There are following possibilities
1. A app.config has hard coded path to .mdf file

2. Somewhere on the form or in class file, this path has been defined.

Look for ".mdf" in your entire solution & then modify it.
0
 
CodeCruiserCommented:
What error do you get?
0
 
thenrichAuthor Commented:
I just went back to SQL express 2012 and now don't have any problems.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now