Share via

Connecting a SQL Express 2008 R2 database to Visual Studio 2017 without upgrading it

Aarón BD 65 Reputation points
Jul 2, 2023, 9:47 PM

I am looking for a way to get a form application that I currently have designed in Visual Studio 2017 to run on Windows XP.

To do this (and as far as my limited knowledge allows me to understand), the program must use the .NET Framework 4 and a SQL Express 2008 R2 database (both compatible with Windows XP Service Pack 3). If this is not the case please correct me.

The problem is that, of the two versions I have of the database (one in SQL Server Express 2014 version and the other in SQL Server Express 2008 R2), only the first one is accepted when added as DataSource. The second one needs to be upgraded to a newer version, but of course that would mean, or so I understand, that it would no longer be a compatible database with Windows XP as it would reach a higher version than it can tolerate.

Faced with this situation, and recognising that I am quite lost in this matter, I would like to ask for help or guidance.

Thank you very much in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,250 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,170 questions
{count} votes

Accepted answer
  1. LiHongMSFT-4306 29,666 Reputation points
    Jul 3, 2023, 2:50 AM

    Hi @Aarón BD

    Visual Studio 2017 does not support SQL Server 2008 R2. User's image

    Refer to this article: Visual Studio 2017 Platform Targeting and Compatibility VS.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 45,381 Reputation points
    Jul 3, 2023, 5:48 AM

    MS SQL Server Express 2008 R2 with SP is out-of-mainstream-support since Jul 9, 2019; that's 4 years ago.

    https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2008-r2

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.