Solved

VS 2008 connecting to SQL 2012

Posted on 2016-07-18
8
42 Views
Last Modified: 2016-08-02
Is there anyway to work round this. I think I might have asked this question before but then got moved to a different project and never got an answer.
I have a web application which was built using VS 2008 and SQL 2005 which worked great, we moved it to SQL2008 and now to SQL2012 and it works, but now I have been asked to add more usage to it so I built the tables and stored procedures in the database.
I am now trying to add the tables and stored procedures to the dbml file, but when I try to connect to the SQL server I get a
This server is not supported. Only servers up to Microsoft SQL Server 2005 are Supported."

Open in new window


How can I put a mapping to the new table and stored procedures from the application to the SQL 2012 DB.

Any help would be greatly appreciated and if you need me to clarify anything I will ASAP.

Thanks in advance.
0
Comment
Question by:Niall292
[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
  • 5
  • 3
8 Comments
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 41717840
For Visual Studio to connect to and work with SQL Server 2012, I believe you will need to download and install SQL Server Data Tools (SSDT) for SQL Server 2012.
0
 

Author Comment

by:Niall292
ID: 41717884
It looks like I already had installed this. I have 3 different version of VS on my PC (2008, 2012, 2015), but this error is only in VS 2008
0
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 41718188
Ok. What is the patch level of Visual Studio 2008? VS2008 SP1 introduced the support for SQL 2012 and hence I am wondering if your are on a lower patch-level for Visual Studio 2008.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:Niall292
ID: 41718271
Looking up Service Pack 1 (KB947888) and (KB948484) are both installed.

Thank you for taking the time to help with this
0
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 41719862
You may also need to change the provider:

Open VS | Tools | Connect to Database | Microsoft SQL Server
Change the Data Provider from .NET Framework Data Provider for SQL Server to .NET Framework Data Provider for OLE DB
Leave the “Always use this selection” checked and click Continue.
0
 

Accepted Solution

by:
Niall292 earned 0 total points
ID: 41723034
I tried this and it gives me a different error. I am using something now which so far it looks like it's working. Instead of trying to drag the new tables and stored procedures into the dbml. I am adding them by using a Partial class (dataContext) and building the table there and pointing and mapping to the tables in the DB.
So far it seems to be working great. Let you know when I have it complete
0
 

Assisted Solution

by:Niall292
Niall292 earned 0 total points
ID: 41732867
I was able to do all CRUD methods after building the tables by code in a partial class DataContext. I had to use Linq to SQL (which I don't mind) to go directly to the tables as I couldn't get executing stored procedures to work.
0
 

Author Closing Comment

by:Niall292
ID: 41738720
This solution give me what I needed for now until we can update the whole application to 2015
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Easiest intro into .NET CORE? 2 32
.NET Core supports which cell phone platforms? 3 34
Search Text in Views 2 27
Sql server query 8 20
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

739 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