Hi, Adrian,
On Sat, Mar 1, 2025 at 7:06 PM 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 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
> >> adrian.klaver@aklaver.com
> >>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
