Guy Barrette, Microsoft, Regional Director, Montreal, Canada, Visual Studio, .NET Expertise Visual Studio 2005 Support for SQL Server 2008 CTP - Guy Barrette

Guy Barrette

Microsoft Regional Director, Montreal, Canada

Visual Studio 2005 Support for SQL Server 2008 CTP

Visual Studio 2005 has no "out of the box" support for SQL Server 2008.  Microsoft has made available an update in the form of a CTP that allow VS 2005 to connect to a SQL Server 2008 CTP5 server.

quote.png
This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2005 design tools, you may receive the following error message:
“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”
This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008 CTP5 :

  • Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release.
  • SQL CLR projects that target SQL Server 2008 CTP5 can be created and deployed to the server.
  • T-SQL and SQL CLR debugging are now enabled for SQL Server 2008 CTP5.
  • Data binding features in Client and Web Projects are enabled.

This CTP does not support the following features for SQL Server 2008 Nov CTP:

  • Creating and editing table schemas in Table Designer or Database Diagrams. The table designer feature in SQL Server Management Studio 2008 can be used to edit table schemas in SQL Server 2008 CTP5.

unquote.png

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en

 

 

Posted: Nov 20 2007, 06:52 PM by guybarrette | with 11 comment(s)
Filed under:

Comments

manoj sagoi said:

hi,

can i use sql-server2008 for asp.net 2005 applications,

please reply on my mail

# January 16, 2010 6:33 AM

Khaldon Al.Beik said:

hi,

i faced the problem of vs.net 2005 is not able to connect to sql 2008 through server explorer, and i downloaded the CTP that you provided in the link above.

but when trying to run the file "VS80sp1-KB954961-X86-INTL.exe" the following message appears :

the upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

plzzz help me with this.

# January 27, 2010 3:19 AM

Carlos said:

Hola, tengo el mismo problema que la persona anterior, cuando quiero instalar ese prorama me dice:

la revisión de actualización no puede ser instalado por el servicio Windows Installer ya que el programa que desea actualizar es posible que falte, o el parche de actualización puede actualizar una versión diferente del programa. Compruebe que el programa que desea actualizar existe en su equipo y que tiene la revisión de actualización correcta.

Que puedo hacer

# February 18, 2010 9:12 AM

Farzinr@rndesign.com said:

I have same problem

Looking for solution

Thanks

# March 1, 2010 2:14 PM

londhe kunal said:

I have also Same problem

please help mi out

www.pareessolutions.com

# May 28, 2010 5:50 AM

matias said:

hola, no he podido aun poder instalar el parche que soluciona el problema de conexion entre vb 2005 y sql server 2008

# June 24, 2010 2:11 PM

Priyanka said:

hi,

i faced the problem of vs.net 2005 is not able to connect to sql 2008 through server explorer, and i downloaded the CTP that you provided in the link above.

but when trying to run the file "VS80sp1-KB954961-X86-INTL.exe" the following message appears :

the upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

plzzz help me with this.

# June 30, 2010 3:39 PM

JAcobo Cano said:

Hi

I have the same problem...

the upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

# August 28, 2010 11:42 AM

Joe said:

I think the patch only works on Visual Studio 2005 Professional or above - it doesn't work with the Standard or Express editions.  That was the only information I found on not being able to apply the patch.

# August 30, 2010 11:33 AM

mehul jadav said:

hi,

can i use sql-server2008 for asp.net 2005 applications,

please reply on my mail

# October 9, 2010 7:16 AM

quangha said:

i have same erro, but not ansewrs

# October 12, 2011 6:13 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)