DevHeads.net

A problem with odbc connection

By Ivan Neshta at 09/12/2018 - 10:07

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:28

Hi 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:50

Hello 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:55

Ivan 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