Hello there,
I have experiencing a problem with odbc connection to postgresql.
I have rhel 7.4 and postgresql-odbc.x86_64 (09.03.0100-2.el7) installed.
Application shows following error: [unixODBC]ERROR: Unsupported startup
parameter: geqo
I've tried to add to the setting in files /etc/odbcinst.ini and
/etc/odbc.ini:
set geqo = 0
set geqo = off
geqo = 0
geqo = off
Unfortunatelly, it didn't help to fix the problem.
Could you please advice how the problem can be fixed?
Best regards,
Ivan
Comments
Re: A problem with odbc connection
By Inoue, Hiroshi at 09/13/2018 - 05:28Hi Ivan,
On 2018/09/13 0:07, Ivan Neshta wrote:
Could you please try the following setting in odbc.ini
sslmode = allow
?
regards,
Hiroshi Inoue
Re: A problem with odbc connection
By Ivan Neshta at 09/13/2018 - 05:50Hello Hiroshi,
It worked.
I've spent almost a day trying to solve this issue.
Thank you very much for your help!
Regards,
Ivan
On Thu, Sep 13, 2018 at 1:28 PM Inoue, Hiroshi <h- ... at dream dot email.ne.jp>
wrote:
Re: A problem with odbc connection
By Clemens Ladisch at 09/13/2018 - 02:55Ivan Neshta wrote:
"geqo" is not one of the ODBC driver options:
<a href="https://odbc.postgresql.org/docs/config-opt.html" title="https://odbc.postgresql.org/docs/config-opt.html">https://odbc.postgresql.org/docs/config-opt.html</a>
You can use the "Pqopt" ODBC option to specify the "options" libpq
option to specify the "-c" server command-line option to specify the
"geqo" server parameter:
<a href="https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNECT-OPTIONS" title="https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNECT-OPTIONS">https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-...</a>
Alternatively, you can use the "ConnSettings" ODBC option to execute
an SQL SET command:
ConnSettings = set geqo=off
Regards,
Clemens