Link to home
Create AccountLog in
Avatar of hongclub
hongclub

asked on

Visual studio - Data connection issue

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
Avatar of rgn2121
rgn2121
Flag of United States of America image

What version is the SQL Server?
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.
ASKER CERTIFIED SOLUTION
Avatar of rgn2121
rgn2121
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of hongclub
hongclub

ASKER

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
Sounds like what I posted above...Here is the KB...
http://support.microsoft.com/kb/954961
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
Great news!  Happy to help...!  Please close this when you get the chance...