Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer: http://stackoverflow.com/questions/21065565/when-i-create-a-connection-to-the-datasource-of-an-old-application-throw-me-an

(SELECT @@VERSION = Microsoft SQL Server  2000 - 8.00.760 (Intel X86) 
Dec 17 2002 14:22:05 
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
)

After a search in google I found some workarounds with a similar problem: http://n8v.enteuxis.org/2009/12/getting-microsoft-visual-studio-2005-to-talk-to-microsoft-sql-server-2008/ http://support.microsoft.com/kb/954961/en-us

But two solutions send me to download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support.

I can't install that, because I don't have Visual Studio 2005 and I need "VS2013 - Olds (2000)".

I have installed SQL Server 2008 (which I don't use today) and SQL Server 2012. All SQL Server Installed

Don't exist a 'Microsoft Visual Studio 2013 Update for Microsoft SQL Server Olds'. What can I do?

share|improve this question
add comment

1 Answer 1

Are these backup files from SQL Server 2000? If so, you really should try to get these converted to SQL Server 2008/2012 formats. A blog post from Ahmed Ibrahim walks through a set of scripts that you can run in SQL Server 2008 or 2012 that will allow you to restore these backups into 2008/2012 and convert them. This will allow you to access easily from VS2012/2013.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.