public inbox for [email protected]  
help / color / mirror / Atom feed
From: Igor Korot <[email protected]>
To: Adrian Klaver <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Version compatibility
Date: Tue, 4 Mar 2025 17:00:23 -0600
Message-ID: <CA+FnnTzuU2VT-7YN=YrVaaM3dnd99yPkSKofTjuvjgoUbLmj3g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+FnnTyZu-xDz-VqquJeMX1EeK+YCd6WDt33AeycKezyR9bCkw@mail.gmail.com>
	<[email protected]>
	<CA+FnnTyk4063qWwW5Z_72QjiLB_f-NSZ-EyeSTKZo+MDkaJo+A@mail.gmail.com>
	<[email protected]>
	<CA+FnnTw4+RA8-n4+5uSZ6-TFFf2cnjm+oqmyVaun6McvYRbGNw@mail.gmail.com>
	<[email protected]>

Hi, Adrian,

On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver <[email protected]> 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 something
> >> like:
> >>
> >> [ODBC Data Sources]
> >> Postgresql = 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 = This is my Postgres DSN.
> >
> > [PostgreSQL]
> > Driver=PostgreSQL
> > Server=localhost
> > PORT=5432
> > DATABASE=draft
> > OOPTION=3
> > USER=postgres
> > PASSWORD=wasqra
> > 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 source 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 solution.
> >>
> >>
> >>
> >> --
> >> Adrian Klaver
> >> [email protected]
> >>
>
> --
> Adrian Klaver
> [email protected]
>






view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Version compatibility
  In-Reply-To: <CA+FnnTzuU2VT-7YN=YrVaaM3dnd99yPkSKofTjuvjgoUbLmj3g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox