Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lteEH-0007rr-5C for pgsql-odbc@arkaria.postgresql.org; Wed, 16 Jun 2021 22:41:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lteEG-0001n8-0p for pgsql-odbc@arkaria.postgresql.org; Wed, 16 Jun 2021 22:41:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lteEF-0001n0-Pm for pgsql-odbc@lists.postgresql.org; Wed, 16 Jun 2021 22:41:47 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lteEB-0005AK-HV for pgsql-odbc@lists.postgresql.org; Wed, 16 Jun 2021 22:41:47 +0000 Received: by mail-ot1-x329.google.com with SMTP id 5-20020a9d01050000b02903c700c45721so4183102otu.6 for ; Wed, 16 Jun 2021 15:41:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=FAuH/9AJ7E8c1r7NruLhLkeceuaXx+p3jra0VwWu4mQ=; b=CKl3uSgVXYE1NfcxEQGWlNjng3iyqH18OS48jz63OcuVxnqDTaOoYL9hbNgOE8l5CU nKcuoaB0+ZngGuhPHfNODrPCo1byzq9V9ap7zGtXW56v0+U9c1BQZ4M4FWNbcqr69rKk vlPbUXR1Ho9n+CryxHxcmLpHBviWVDWR29Hl94n4Z7XURwx6FMu5VboF+TjO6KV81XKj QXZwmIVrnIsI47mAUZVD+rw075FEUy7dt2dAqDrlaKqK8QF98ChU+f00RKrabpCK+vGE W8BLYcG6onSKZVNXy+sIv62G01evwo/frDE5EcIVcCmW+O0x4u0lg1g+y4Xv/jg7jwg6 iHYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=FAuH/9AJ7E8c1r7NruLhLkeceuaXx+p3jra0VwWu4mQ=; b=qd8DxoCyKY8nBknOL9Q12016P4t3GMkILYH8PrKnltHQ8E9O5kIwe3Q7UThnavfmh1 3nG8F6puIgaJDUzcApBgN6i5jxDxu8phBI92Rwae1nozeEm6bbuBf9LfHYzJ3Bmk5ZQa xlOnaqofkBIJHTvqaGh7iioeXPVg+ZM1iKnV/mTwIGr5Cg8k9PHTLJal0tID9YvCD+Bd CkiFW0W5hb1kPL1LHyIagOAtj9Q8bQ11oLN0dhTi2EEAf2DhwQX/tWh51G7WdePMoO7t VdaywR9L5TZexAMazhVGzJfmRjpDwIZraM+0luBcEO3+z+BPKtP9eK2yo1qssrddPM3s 2+fA== X-Gm-Message-State: AOAM53032tfnqFR1IXjctsqQXk5fqZeiaxjQz1KGdRPMr1EqZZwzaWjx Y7ikQ1eTHL1uUqwJhbQTpYsUrzAlyRY= X-Google-Smtp-Source: ABdhPJyB3rDLvNQJLuEn/RR7d+lnDkvtM1vocKZcQ/basyJMQp8K0fszte5aQ1uJkhYZCQDhppQGSw== X-Received: by 2002:a9d:3644:: with SMTP id w62mr1846028otb.205.1623883300983; Wed, 16 Jun 2021 15:41:40 -0700 (PDT) Received: from [10.138.0.150] ([45.132.115.127]) by smtp.gmail.com with ESMTPSA id i28sm499971otj.41.2021.06.16.15.41.40 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 16 Jun 2021 15:41:40 -0700 (PDT) Subject: Re: Relation between postgresql-Version and psqlODBC-Version To: pgsql-odbc@lists.postgresql.org References: <20210616110558.Horde.-PJM-SIKnp-Qx5c1ZYzZL54@webmail.uni-frankfurt.de> From: Danny Severns Message-ID: <61e74f4e-6661-5d6c-170a-9748f29f925e@gmail.com> Date: Wed, 16 Jun 2021 17:41:39 -0500 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: <20210616110558.Horde.-PJM-SIKnp-Qx5c1ZYzZL54@webmail.uni-frankfurt.de> Content-Type: multipart/alternative; boundary="------------5CE2732A4780A79C389562DF" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------5CE2732A4780A79C389562DF Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit If I understand the question, yes there is a relationship.  I would say your latter statement is correct.  As far as I know, the ODBC drivers are backwards compatible but not forward compatible, although most things in ODBC 11 would work with 12, just not new features not comprehended in the older ODBC driver. On 6/16/2021 4:05 AM, Linus Hassel wrote: > > Dear Ladies and Gentlemen, > > is there any relation between the postgresql-Version and > psqlODBC-Version? So is it possible to run a postgresql-server in > version 12 and get a working  connection with psqlODBC-driver version > 11.01.0000? Or have i to upgrade the driver to version 12x when i run > a postgresql server in version 12.x? > > Best regards, > > Linus Hassel > > > > Mit freundlichen Grüßen, > > Linus Hassel > ________________________________________ > > Goethe Universität Frankfurt/M > Hochschulrechenzentrum > Theodor-W.-Adorno-Platz 1 > 60323 Frankfurt am Main > > Arbeitsgruppe Campus Management > > E-Mail: hassel at rz.uni-frankfurt.de > Phone : +49 (69) 798 17276 > URL   : http://www.uni-frankfurt.de/hrz --------------5CE2732A4780A79C389562DF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

If I understand the question, yes there is a relationship.  I would say your latter statement is correct.  As far as I know, the ODBC drivers are backwards compatible but not forward compatible, although most things in ODBC 11 would work with 12, just not new features not comprehended in the older ODBC driver.

On 6/16/2021 4:05 AM, Linus Hassel wrote:

Dear Ladies and Gentlemen,

is there any relation between the postgresql-Version and psqlODBC-Version? So is it possible to run a postgresql-server in version 12 and get a working  connection with psqlODBC-driver version 11.01.0000? Or have i to upgrade the driver to version 12x when i run a postgresql server in version 12.x?

Best regards,

Linus Hassel



Mit freundlichen Grüßen,

Linus Hassel
________________________________________

Goethe Universität Frankfurt/M
Hochschulrechenzentrum
Theodor-W.-Adorno-Platz 1
60323 Frankfurt am Main

Arbeitsgruppe Campus Management

E-Mail: hassel at rz.uni-frankfurt.de
Phone : +49 (69) 798 17276
URL   : http://www.uni-frankfurt.de/hrz
--------------5CE2732A4780A79C389562DF--