Home > IT Answers > SQL Server > Will Visual Studio 2003 and SQL Server 2008
CGarnett
15 pts.
 Will Visual Studio 2003 and SQL Server 2008
SQL Server 2008, Visual Studio 2003
Will Visual Studio 2003 work with SQL Server 2008 databases.

Software/Hardware used:
Microsoft Server 2003
ASKED: December 22, 2009  2:15 PM
UPDATED: December 23, 2009  2:06 PM
RELATED QUESTIONS
Answer Wiki:
Yes you can connect an application written in Visual Studio 2003 to a SQL Server 2008 database without issue. As long as you have the correct driver installed on the machine you can connect just about anything to SQL Server.
Last Wiki Answer Submitted:  December 22, 2009  9:30 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You could, however, encounter some limitations at design time, and will probably not be able to take advantage of some new features when designing new applications that don’t interact with SQL Server programmatically only.

I think that even with VS 2005 and 2008, a patch is needed in order to overcome those limitations.

carlosdl
 63,580 pts.
 

Will I be able to update the recordsets and the database while using Visual Studio 2003 and SQL Server 2008? Some of the post that I have read have spoke about a patch that I needs to be install. The patch from my understanding is only valid for Visual Studio 2005 and not Visual Studio 2003.

CGarnett
 15 pts.
 

I think the patch was released for VS 2005 and 2008 only, but you should be able to perform updates and almost any other operation without issues.

You might want to make some tests to be sure.

carlosdl
 63,580 pts.