Content-Type: multipart/alternative;
 boundary="------------lfj0XO93pHrFfJp61eIjYKwa"
Message-ID: <b1b49fa7-4e4b-4586-922f-e44f5e78c0e7@couderc.eu>
Date: Fri, 13 Oct 2023 12:14:50 +0200
MIME-Version: 1.0
Subject: Re: 32 bit DLL's
Content-Language: en-US
To: Dave Cramer <davecramer@postgres.rocks>
Cc: pgsql-odbc@lists.postgresql.org
References: 
 <CADK3HHKMgBxV7szqS=v5NgT4LGSO94qCY36MOCaXyQ3hPW+_QA@mail.gmail.com>
 <5293461c-b198-4186-90e2-9ceda9b56ea4@couderc.eu>
 <CADK3HH+KTqHWqb4Jgk=_X2JF9NHidO2Bmgo8P-pbJxW4OS=BYA@mail.gmail.com>
 <CADK3HHJiPopZxKm7vm3BjANy_Jy=LNw55oLh1KB-yJpDue_hHw@mail.gmail.com>
From: Pierre Couderc <pierre@couderc.eu>
In-Reply-To: 
 <CADK3HHJiPopZxKm7vm3BjANy_Jy=LNw55oLh1KB-yJpDue_hHw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/b1b49fa7-4e4b-4586-922f-e44f5e78c0e7%40couderc.eu>
Precedence: bulk

This is a multi-part message in MIME format.
--------------lfj0XO93pHrFfJp61eIjYKwa
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Le 10/13/23 à 11:55, Dave Cramer a écrit :
>
>
>
> On Fri, 13 Oct 2023 at 05:45, Dave Cramer <davecramer@postgres.rocks> 
> wrote:
>
>
>     Dave Cramer
>     www.postgres.rocks
>
>
>     On Fri, 13 Oct 2023 at 03:59, Pierre Couderc <pierre@couderc.eu>
>     wrote:
>
>         Le 10/12/23 à 15:17, Dave Cramer a écrit :
>>         I noticed that the project currently provides 32bit DLL's in
>>         the release.
>>
>>         Is anyone using them?
>>
>>         Dave Cramer
>
>         Absolutely !
>
>         We have migrated a big old ODBC 32 bits project from
>         Access/SQL Server to ODBC32bits  Postgresql because of
>         stability of Postgresql.  Many 32bits projects developed in
>         90's continue to be used and run on modern computers...
>
>         We maintain old VC6 32bits projects (MS FORTRAN+MS VC6+ODBC)
>         using an XP VM on modern (linux...) computer. And the .exe
>         resulting  of these projects run on W10/W11 computers with
>         modern Posgresql...
>
>         Independence of MS is strategic !
>
>         Pierre Couderc
>
>
>
>     OK, I think I have the message :)
>
>     Thanks
>
>     Dave
>
>
> Building PostgreSQL on 32bits in order to get libpq dll's seems to be 
> challenging. If anyone has some experience doing this, let me know.
>
> Also I plan on moving development to github 
> postgresql-interfaces/psqlodbc (github.com) 
> <https://github.com/postgresql-interfaces/psqlodbc>
>
> Dave

Mmm, sorry I know nothing of "building 32 bits dll" but the only point 
is to keep PSQLODBC30A.DLL ans PSQLODBC35W.DLL as they are now.

Moreover, I do not think useful (for me!!) to add modern new features of 
last Postgesql to the ODBC 32bits interface, that is "maintain" but not 
necessarily "improve"...

PC

--------------lfj0XO93pHrFfJp61eIjYKwa
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Le 10/13/23 à 11:55, Dave Cramer a
      écrit :<br>
    </div>
    <blockquote type="cite"
cite="mid:CADK3HHJiPopZxKm7vm3BjANy_Jy=LNw55oLh1KB-yJpDue_hHw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr">
          <div dir="ltr"><br>
            <br>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr" class="gmail_attr">On Fri, 13 Oct 2023 at
              05:45, Dave Cramer <a class="moz-txt-link-rfc2396E" href="mailto:davecramer@postgres.rocks">&lt;davecramer@postgres.rocks&gt;</a>
              wrote:<br>
            </div>
            <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
              <div dir="ltr">
                <div dir="ltr"><br clear="all">
                  <div>
                    <div dir="ltr" class="gmail_signature">
                      <div dir="ltr">Dave Cramer
                        <div><a class="moz-txt-link-abbreviated" href="http://www.postgres.rocks">www.postgres.rocks</a></div>
                      </div>
                    </div>
                  </div>
                  <br>
                </div>
                <br>
                <div class="gmail_quote">
                  <div dir="ltr" class="gmail_attr">On Fri, 13 Oct 2023
                    at 03:59, Pierre Couderc &lt;<a
                      href="mailto:pierre@couderc.eu" target="_blank"
                      moz-do-not-send="true"
                      class="moz-txt-link-freetext">pierre@couderc.eu</a>&gt;
                    wrote:<br>
                  </div>
                  <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                    <div>
                      <div>Le 10/12/23 à 15:17, Dave Cramer a écrit :<br>
                      </div>
                      <blockquote type="cite">
                        <div dir="ltr">I noticed that the project
                          currently provides 32bit DLL's in the release.
                          <div><br>
                          </div>
                          <div>Is anyone using them?</div>
                          <div><br clear="all">
                            <div>
                              <div dir="ltr" class="gmail_signature">Dave
                                Cramer</div>
                            </div>
                          </div>
                        </div>
                      </blockquote>
                      <p>Absolutely !<br>
                      </p>
                      <p>We have migrated a big old ODBC 32 bits project
                        from Access/SQL Server to ODBC32bits  Postgresql
                        because of stability of Postgresql.  Many 32bits
                        projects developed in 90's continue to be used
                        and run on modern computers...</p>
                      <p>We maintain old VC6 32bits projects (MS
                        FORTRAN+MS VC6+ODBC) using an XP VM on modern
                        (linux...) computer. And the .exe resulting  of
                        these projects run on W10/W11 computers with 
                        modern Posgresql...</p>
                      <p>Independence of MS is strategic !</p>
                      <p>Pierre Couderc</p>
                    </div>
                  </blockquote>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                  <div>OK, I think I have the message :)</div>
                  <div><br>
                  </div>
                  <div>Thanks</div>
                  <div><br>
                  </div>
                  <div>Dave </div>
                </div>
              </div>
            </blockquote>
            <div><br>
            </div>
            <div>Building PostgreSQL on 32bits in order to get libpq
              dll's seems to be challenging. If anyone has some
              experience doing this, let me know.</div>
            <div><br>
            </div>
            <div>Also I plan on moving development to github <a
                href="https://github.com/postgresql-interfaces/psqlodbc"
                moz-do-not-send="true">postgresql-interfaces/psqlodbc
                (github.com)</a></div>
            <div><br>
            </div>
            <div>Dave <br>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <p>Mmm, sorry I know nothing of "building 32 bits dll" but the only
      point is to keep PSQLODBC30A.DLL ans PSQLODBC35W.DLL as they are
      now.</p>
    <p>Moreover, I do not think useful (for me!!) to add modern new
      features of last Postgesql to the ODBC 32bits interface, that is
      "maintain" but not necessarily "improve"...</p>
    <p>PC<br>
    </p>
  </body>
</html>

--------------lfj0XO93pHrFfJp61eIjYKwa--