0

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: https://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?

1 Answer 1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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