Solved

connect to .mdf

Posted on 2014-04-20
5
234 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this tutorial viewers will learn how add a full-size background image to a webpage using CSS3. Create a new HTML document with an internal stylesheet.: In CSS, define the html element to have a background image. Use a high resolution image.: In t…
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…

707 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