MIME-Version: 1.0
References: <CA+FnnTyZu-xDz-VqquJeMX1EeK+YCd6WDt33AeycKezyR9bCkw@mail.gmail.com>
 <4cf9c771-218c-495f-96af-98d162cc2ccc@aklaver.com> <CA+FnnTyk4063qWwW5Z_72QjiLB_f-NSZ-EyeSTKZo+MDkaJo+A@mail.gmail.com>
 <a40fce91-c028-41ae-a623-4c938871c343@aklaver.com> <CA+FnnTw4+RA8-n4+5uSZ6-TFFf2cnjm+oqmyVaun6McvYRbGNw@mail.gmail.com>
 <f3888276-9f94-4c0c-86fb-0c33d296f9c9@aklaver.com>
In-Reply-To: <f3888276-9f94-4c0c-86fb-0c33d296f9c9@aklaver.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Tue, 4 Mar 2025 17:00:23 -0600
Message-ID: <CA+FnnTzuU2VT-7YN=YrVaaM3dnd99yPkSKofTjuvjgoUbLmj3g@mail.gmail.com>
Subject: Re: Version compatibility
To: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTzuU2VT-7YN%3DYrVaaM3dnd99yPkSKofTjuvjgoUbLmj3g%40mail.gmail.com>
Precedence: bulk

Hi, Adrian,

On Sat, Mar 1, 2025 at 7:06=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver=
.com> wrote:
>
> On 3/1/25 21:17, Igor Korot wrote:
>
> >>
> >> Do you have a $HOME/.odbc.ini?
> >>
> >> Also in odbc.ini, per man odbc.ini, I believe you have to have somethi=
ng
> >> like:
> >>
> >> [ODBC Data Sources]
> >> Postgresql =3D This is my Postgres DSN.
> >
> > I added it and now my odbc.n look like this:
> >
> > [code]
> > igor@IgorsGentoo ~/dbhandler/Debug $ cat /etc/unixODBC/odbc.ini
> > [ODBC Data Sources]
> > PostgreSQL =3D This is my Postgres DSN.
> >
> > [PostgreSQL]
> > Driver=3DPostgreSQL
> > Server=3Dlocalhost
> > PORT=3D5432
> > DATABASE=3Ddraft
> > OOPTION=3D3
> > USER=3Dpostgres
> > PASSWORD=3Dwasqra
> > igor@IgorsGentoo ~/dbhandler/Debug $
>
> Did the connection work after making the change?

Sorry somehow missed that reply,

No still getting the same error...

Thank you.

>
> >
> > [/code]
> >
> > And there is no .odbc.nii n the ~:
> >
> > [code]
> > igor@IgorsGentoo ~/dbhandler/Debug $ ls -la ~/.o*
> > -rw-r--r-- 1 igor igor 0 Mar  1 23:10 /home/igor/.odbc.ini
> > igor@IgorsGentoo ~/dbhandler/Debug $ cat /home/igor/.odbc.ini
> > igor@IgorsGentoo ~/dbhandler/Debug $
> > [/code]
> >
> > Apparently the file is created when  run "isql -v PostgreSQL".
> > I will look into that.
> >
> > Thx.
> >
> >
> >
> >>
> >>   From man odbc.ini:
> >>
> >> "[ODBC Data Sources] section
> >>
> >>          The required section [ODBC Data Sources] lists each data sour=
ce name
> >> (DSN) as a key. The associated values serve as comments. Each  entry
> >> must be matched by an ini file [section] describing the data source.
> >> "
> >>
> >>> I'd like to develop backward compatible software which is compatible
> >>> with the oldest possible combination..
> >>
> >> Not following.
> >>   From my experiences with the ODBC driver it is backwards compatible,=
 so
> >> I would think using a more recent version would be the preferred solut=
ion.
> >>
> >>
> >>
> >> --
> >> Adrian Klaver
> >> adrian.klaver@aklaver.com
> >>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>