| From: | Clemens Ladisch <clemens(at)ladisch(dot)de> |
|---|---|
| To: | Keith Yanase <keith(dot)yanase(at)soterawireless(dot)com>, pgsql-odbc(at)postgresql(dot)org |
| Cc: | "Bhavika Padidala (MINDTREE LIMITED)" <v-bhpadi(at)microsoft(dot)com>, support <support(at)mail(dot)support(dot)microsoft(dot)com>, "Vikram Ramagiri (MINDTREE LIMITED)" <v-virama(at)microsoft(dot)com>, "Prashanth Reddy Kalvakuntla (MINDTREE LIMITED)" <v-prkalv(at)microsoft(dot)com> |
| Subject: | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |
| Date: | 2020-01-18 10:55:42 |
| Message-ID: | ed5c3981-461c-bd29-5d01-d176028dee25@ladisch.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Keith Yanase wrote:
> I’m having difficulties connecting to our postgresql database through
> SSH tunneling when using the ODBC driver.
Do you mean SSH or SSL?
psqlODBC has no built-in support for SSH tunneling.
I would recommend to use SSL. But if the server allows only SSH, then
you have to manually create an SSH tunnel with OpenSSH, and tell
psqlODBC to connect to that port on localhost.
> I’m able to connect to the database in DBeaver.
As far as I can see, DBeaver's SSH support is separate from the
database drivers, i.e., DBeaver creates the SSH tunnel by itself,
and then hands off that port to the database driver.
Regards,
Clemens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Yanase | 2020-01-19 00:11:52 | Re: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |
| Previous Message | Keith Yanase | 2020-01-17 22:25:21 | RE: [EXTERNAL] Re: Case 120011521001709 - Issues connecting to postgreSQL server |