[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Visual studio - Data connection issue

Posted on 2011-02-15
7
Medium Priority
?
388 Views
Last Modified: 2013-11-26
Hi,

I have VS2005, and making a crystal report.

I am trying to create a Data Connections in VS, when i add connection and put the login, everything works fine, i can see the SQL server name etc.

But when i click on 'OK', VS gave me error:
"This server version is not supported. You must have Microsoft SQL Server 2005 Beta2 or later"

Please advise,
Tommy
0
Comment
Question by:hongclub
[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
  • 4
  • 2
7 Comments
 
LVL 12

Expert Comment

by:rgn2121
ID: 34899499
What version is the SQL Server?
0
 
LVL 9

Expert Comment

by:rawinnlnx9
ID: 34899516
Get the latest service pack for SQL Server 2005 (I believe it's SP2.) and install that on your SQL Server. Then make sure you have the latest service pack for Visual Studio as well.

It's sounds to me like you have incompatible versions of tools that you are using. So update both Visual Studio and SQL Server. That should fix it.
0
 
LVL 12

Accepted Solution

by:
rgn2121 earned 2000 total points
ID: 34899585
Also, do you have Standard or Professional VS?  Looks like you might need the following, although I don't know the versions of software you are using yet.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 

Author Comment

by:hongclub
ID: 34899705
i have vs 2005 professional, and i have SQL server 2008 R2 in the production server.

I can't upgrade that SQL server, it is my company server, everyone is using it.
any suggestion ?

Tommy
0
 
LVL 12

Expert Comment

by:rgn2121
ID: 34899813
Sounds like what I posted above...Here is the KB...
http://support.microsoft.com/kb/954961
0
 

Author Comment

by:hongclub
ID: 34899890
hi rgn2121,

your solution rocks, after i installed this update:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en

it works!!!

Tommy
0
 
LVL 12

Expert Comment

by:rgn2121
ID: 34906117
Great news!  Happy to help...!  Please close this when you get the chance...
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

656 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