Thread: A problem with odbc connection
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
Ivan Neshta wrote: > [unixODBC]ERROR: Unsupported startup parameter: geqo "geqo" is not one of the ODBC driver options: https://odbc.postgresql.org/docs/config-opt.html 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: https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-CONNECT-OPTIONS Alternatively, you can use the "ConnSettings" ODBC option to execute an SQL SET command: ConnSettings = set geqo=off Regards, Clemens
Hi Ivan, On 2018/09/13 0:07, Ivan Neshta wrote: > 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 > Could you please try the following setting in odbc.ini sslmode = allow ? regards, Hiroshi Inoue > Unfortunatelly, it didn't help to fix the problem. > Could you please advice how the problem can be fixed? > > Best regards, > Ivan --- このメールは、AVG によってウイルス チェックされています。 http://www.avg.com
Hello Hiroshi,
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-inoue@dream.email.ne.jp> wrote:
Hi Ivan,
On 2018/09/13 0:07, Ivan Neshta wrote:
> 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
>
Could you please try the following setting in odbc.ini
sslmode = allow
?
regards,
Hiroshi Inoue
> Unfortunatelly, it didn't help to fix the problem.
> Could you please advice how the problem can be fixed?
>
> Best regards,
> Ivan
---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com