Zum Hauptinhalt gehen

connecting to PostgreSQL

Permanently deleted user
I am having a problem in connecting a PostgreSQL . I am unable to connect to database. Though other databases like ORACLE 11gR2 , SQL SERVER is conecting, I have a doubt, does it support POSTGRESQL or not ? If Yes, then how to connect is there any guide if not then why cant we connect to POSTGRESQL ?
0

Kommentare

5 Kommentare

Datum Stimmen
  • Mike Ketler
    Hi,

     

    Sorry for the delay, you'll need to make sure you are using the odbc driver for PostgreSQL and the correct connection string. 

     

    https://odbc.postgresql.org/

     

    Driver={PostgreSQL ANSI(x64)};Server=support3;Port=5432;Database=projects;Uid=postgres;Pwd=password;

     

    Thanks,

     

    Mike Ketler
    0
  • Permanently deleted user
    This worked great for getting our data conection established, and we were even pretty hopeful when the table and all the data fields showed up while configuring our data link. However, none of our postgresql data is actually showing up in the results list or in our report.....  Any clues would be appreciated!!!??
    0
  • Tom Neer
    @Lisa - Be sure you are using a username and password that has access to the data. Mike's example uses the "postgres" user which is not recommended. This account should never be exposed. It would be best to create an separate "webuser" account or use OS auth. You will need to apply permissions to the table(s).
    0
  • Justin Chisum

    Tom, 

    I know this post is fairly old, but did granting permissions in PostGres on the table actually resolve the issue? I'm actually having the same issue. My connection to PostGres is successful, but my no results return in my data link and I have granted the appropriate privileges to the PostGres database. 

    0
  • Tom Neer
    Justin, Thank you for your patience, it's been a crazy month. It sounds like you have your connection setup. So it sounds like you don't have the query in your service set correction. In the layer's Data Link page, be sure to use a question mark as your parameter. Start with a simple query, such as "SELECT * FROM yourtable WHERE objected = ?;". It helps to put a known value into the Parameters "Default Value" (see attached) Two things help in debugging this. Check your Geocortex logs and click the link to test against the REST endpoing. Best, -Tom
    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.

Sie haben nicht gefunden, wonach Sie suchten?

Neuer Post