Postgresql ODBC connection

Options
ViorelHoroi
ViorelHoroi Posts: 7 Fluorite Rank Badge
in Leapfrog

Can someone explain me where to find information about editing the ODBC connection to a postgresql database?

Thanks!

Tagged:

Answers

  • ViorelHoroi
    ViorelHoroi Posts: 7 Fluorite Rank Badge

    That's Ok. I figured out how to do it

  • RiyanAbraham
    RiyanAbraham Posts: 1

    how did you do it?

    i just get

    "An error occurred when reading "collar":
('42P01', '[42P01] ERROR: relation "collar" does not exist;\nError while executing the query (1) (SQLExecDirectW)')"

  • PrachiChitkara
    PrachiChitkara Posts: 341 admin

    hey @ViorelHoroi great to know you were able to figure it out :) Can you share your findings with @RiyanAbraham

  • ViorelHoroi
    ViorelHoroi Posts: 7 Fluorite Rank Badge

    Hi @RiyanAbraham

    If I understand well your message you figure it out how to connect to the PostgreSQL server (creating an ODBC connecton on your local machine and using that to connect Leapfrog to Postgres).

    For me, the message you obtain is a proof that the connection is working. It's just that, probably, the database on Postgres it's not exactly structured or organised like the Leaqpfrog needs.

    Sorry, I cannot help you more than that.

    In my case, it was just that I did'nt figure out how to configure the ODBC connection.

  • SamuelGilgen
    SamuelGilgen Posts: 5 Corundum Rank Badge

    Hi everybody

    I would like to follow on this. I got the same error as @RiyanAbraham :

    image.png

    We figured out that the views or tables must be listed under the default schema "public". So now it works.

    I hope that helps anybody in future.

Categories