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