public inbox for [email protected]help / color / mirror / Atom feed
Re: Version compatibility 6+ messages / 2 participants [nested] [flat]
* Re: Version compatibility @ 2025-03-02 05:17 Igor Korot <[email protected]> 2025-03-02 01:06 ` Re: Version compatibility Adrian Klaver <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Igor Korot @ 2025-03-02 05:17 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-general Hi, Adrian, On Sat, Mar 1, 2025 at 12:31 PM Adrian Klaver <[email protected]> wrote: > > On 3/1/25 14:17, Igor Korot wrote: > > Reply to list also. > Ccing list. > > Comments inline. > > > Hi, Adrian, > > On Sat, Mar 1, 2025 at 11:23 AM Adrian Klaver <[email protected] > > <mailto:[email protected]>> wrote: > > > > On 3/1/25 13:15, Igor Korot wrote: > > > Hi, ALL, > > > I have PostgreSQL version 13 and ODBC driver version 11 > > > on my Gentoo box. > > > > > > Are they compatible? Can I still connect to the server? > > > > Have you tried to make a connection? > > > > > > Tried. > > > > [code] > > IgorsGentoo/home/igor/dbhandler_new/Debug #cat /etc/unixODBC/odbcinst.ini > > Trace=yes > > TraceFile=/tmp/sql.log > > [PostgreSQL] > > Description=PostgreSQL drver > > Driver=/usr/lib64/psqlodbcw.so > > > > IgorsGentoo/home/igor/dbhandler_new/Debug #cat /etc/unixODBC/odbc.ini > > [PostgreSQL] > > Driver=PostgreSQL > > Server=localhost > > PORT=5432 > > DATABASE=draft > > OOPTION=3 > > USER=postgres > > PASSWORD=wasqra > > IgorsGentoo/home/igor/dbhandler_new/Debug # > > > > igor@IgorsGentoo~/dbhandler/Debug $isql -v PostgreSQL > > [IM002][unixODBC][Driver Manager]Data source name not found and no > > default driver specified > > [ISQL]ERROR: Could not SQLConnect > > igor@IgorsGentoo~/dbhandler/Debug $ > > > > [/code] > > From: > > https://www.mankier.com/1/isql > > "DSN > > The Data Source Name (DSN) used to connect to the SQL database. > unixODBC looks for the specified DSN in /etc/odbc.ini and > $HOME/.odbc.ini, with the latter taking precedence. > " > > 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 $ [/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] > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Version compatibility 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> @ 2025-03-02 01:06 ` Adrian Klaver <[email protected]> 2025-03-04 23:00 ` Re: Version compatibility Igor Korot <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Adrian Klaver @ 2025-03-02 01:06 UTC (permalink / raw) To: Igor Korot <[email protected]>; +Cc: pgsql-general 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? > > [/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] ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Version compatibility 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> 2025-03-02 01:06 ` Re: Version compatibility Adrian Klaver <[email protected]> @ 2025-03-04 23:00 ` Igor Korot <[email protected]> 2025-03-04 21:00 ` Re: Version compatibility Adrian Klaver <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Igor Korot @ 2025-03-04 23:00 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; pgsql-generallists.postgresql.org <[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] > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Version compatibility 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> 2025-03-02 01:06 ` Re: Version compatibility Adrian Klaver <[email protected]> 2025-03-04 23:00 ` Re: Version compatibility Igor Korot <[email protected]> @ 2025-03-04 21:00 ` Adrian Klaver <[email protected]> 2025-03-04 21:05 ` Re: Version compatibility Igor Korot <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Adrian Klaver @ 2025-03-04 21:00 UTC (permalink / raw) To: Igor Korot <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> On 3/4/25 3:00 PM, Igor Korot wrote: > Hi, Adrian, > > On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver <[email protected]> wrote: >> >> On 3/ >> >> Did the connection work after making the change? > > Sorry somehow missed that reply, > > No still getting the same error... This thread: https://forums.gentoo.org/viewtopic-p-8856135.html tells you what the problem is, the software is too old. > > Thank you. > >> >>> -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Version compatibility 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> 2025-03-02 01:06 ` Re: Version compatibility Adrian Klaver <[email protected]> 2025-03-04 23:00 ` Re: Version compatibility Igor Korot <[email protected]> 2025-03-04 21:00 ` Re: Version compatibility Adrian Klaver <[email protected]> @ 2025-03-04 21:05 ` Igor Korot <[email protected]> 2025-03-04 23:24 ` Re: Version compatibility Adrian Klaver <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Igor Korot @ 2025-03-04 21:05 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> Hi, Adrian, On Tue, Mar 4, 2025, 3:00 PM Adrian Klaver <[email protected]> wrote: > > > On 3/4/25 3:00 PM, Igor Korot wrote: > > Hi, Adrian, > > > > On Sat, Mar 1, 2025 at 7:06 PM Adrian Klaver <[email protected]> > wrote: > >> > >> On 3/ > >> > >> Did the connection work after making the change? > > > > Sorry somehow missed that reply, > > > > No still getting the same error... > > This thread: > > https://forums.gentoo.org/viewtopic-p-8856135.html > > tells you what the problem is, the software is too old. > Which one? The driver or DM? Also, does this mean the driver is incompatible with the server version on the protocol used? Thank you. > > > > Thank you. > > > >> > >>> > > -- > Adrian Klaver > [email protected] > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Version compatibility 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> 2025-03-02 01:06 ` Re: Version compatibility Adrian Klaver <[email protected]> 2025-03-04 23:00 ` Re: Version compatibility Igor Korot <[email protected]> 2025-03-04 21:00 ` Re: Version compatibility Adrian Klaver <[email protected]> 2025-03-04 21:05 ` Re: Version compatibility Igor Korot <[email protected]> @ 2025-03-04 23:24 ` Adrian Klaver <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Adrian Klaver @ 2025-03-04 23:24 UTC (permalink / raw) To: Igor Korot <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> On 3/4/25 13:05, Igor Korot wrote: > Hi, Adrian, > tells you what the problem is, the software is too old. > > > Which one? > The driver or DM? I don't know enough about Gentoo to say. If it where me I would upgrade both unixODBC and the Postgres driver to the latest that is supported for the distro. > > Also, does this mean the driver is incompatible with the server version > on the protocol used? > > Thank you. > > > > > > Thank you. > > > >> > >>> > > -- > Adrian Klaver > [email protected] <mailto:[email protected]> > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2025-03-04 23:24 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-02 05:17 Re: Version compatibility Igor Korot <[email protected]> 2025-03-02 01:06 ` Adrian Klaver <[email protected]> 2025-03-04 23:00 ` Igor Korot <[email protected]> 2025-03-04 21:00 ` Adrian Klaver <[email protected]> 2025-03-04 21:05 ` Igor Korot <[email protected]> 2025-03-04 23:24 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox