Solved

connect to .mdf

Posted on 2014-04-20
5
230 Views
Last Modified: 2014-05-02
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
Comment
Question by:thenrich
  • 2
  • 2
5 Comments
 
LVL 7

Accepted Solution

by:
Utkarsh Kulkarni earned 500 total points
ID: 40012583
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
 
LVL 5

Author Comment

by:thenrich
ID: 40012611
Where do I adjust the path?
0
 
LVL 7

Expert Comment

by:Utkarsh Kulkarni
ID: 40014111
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
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 40014792
What error do you get?
0
 
LVL 5

Author Comment

by:thenrich
ID: 40014804
I just went back to SQL express 2012 and now don't have any problems.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question