The existing version is not compatible with the version in which the database was created

Imports System.Data.SqlClient

Public Class DatabaseConnector
    Private connectionStringTemplate As String

    Public Sub New(serverName As String, databaseName As String, username As String, password As String)
        connectionStringTemplate = $"Data Source={serverName};Initial Catalog={databaseName};User ID={username};Password={password};"
    End Sub

    Public Function OpenConnection() As SqlConnection
        Dim connection As New SqlConnection()

        Try
            'Here you would dynamically adjust the connection string based on the database version...
            Dim databaseVersion As String = GetDatabaseVersion()
            Dim connectionString = String.Format(connectionStringTemplate, databaseVersion)

            connection.ConnectionString = connectionString

            connection.Open()
            Console.WriteLine("Connection opened successfully.")
        Catch ex As Exception
            Console.WriteLine($"Error opening connection: {ex.Message}")
        End Try

        Return connection
    End Function

    Public Sub CloseConnection(connection As SqlConnection)
        Try
            connection.Close()
            Console.WriteLine("Connection closed.")
        Catch ex As Exception
            Console.WriteLine($"Error closing connection: {ex.Message}")
        End Try
    End Sub

    Private Function GetDatabaseVersion() As String
        'Your logic to determine the database version dynamically...
        'As an example, you might query the database for its version...
        'Then return a placeholder value "v1.0"...
        Return "v1.0"
    End Function
End Class