| From: | "Paul Suworow" <paul(dot)suworow(at)gmail(dot)com> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Connection to PostgreSQL from Excel |
| Date: | 2018-08-27 20:19:30 |
| Message-ID: | 001f01d43e43$438e30b0$caaa9210$@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Hi team,
Thank you for your great work! I am developing an Excel tool that should allow users to update tables and charts from a PostgreSQL database. My workbook currently connects to the database using the following VBA code:
Set objConnection = CreateObject("ADODB.Connection")
ConnString = "DRIVER={PostgreSQL Unicode};DATABASE=FMS;SERVER=[x];PORT=5432;Uid=[x];Pwd=[x]"
objConnection.Open ConnString
All works fine but the code requires PostgreSQL driver to be installed on user's machine.
Is there an alternative way to connect to a PostgreSQL database without pre-creating DNS or installing any drivers in advance?
Thank you for your help!
Kind regards,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2018-08-27 20:30:34 | Re: Erroneous behavior of primary key |
| Previous Message | Daniel J Peacock | 2018-08-27 19:50:51 | Erroneous behavior of primary key |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kumar, Virendra | 2018-09-04 13:38:43 | psqlODBC |
| Previous Message | Łukasz Jarych | 2018-08-27 08:49:05 | Re: Connection to PostgreSQL from Excel |