| From: | Paul Suworow <paul(dot)suworow(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "jaryszek(at)gmail(dot)com" <jaryszek(at)gmail(dot)com> |
| Cc: | "tom(dot)shriner" <tom(dot)shriner(at)tmpsystems(dot)net> |
| Subject: | Connection to PostgreSQL from Excel |
| Date: | 2018-08-27 07:55:43 |
| Message-ID: | -3a5719ao6eou3leql-edduop-bzcl2t4oi9cm-fxcuey-a4i1c4-jsfglwfhie6bdtabdc-bxwmcnqe0xk7-q0nc5o-n3nir5-dkdwdbkihg1i2s8mhd78g4i3-onf2e0w2oio4nnlmvd-n3k13z-1j3goc.1535355997668@email.android.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-odbc |
Hi team,
I am working on 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 | Łukasz Jarych | 2018-08-27 08:49:05 | Re: Connection to PostgreSQL from Excel |
| Previous Message | Naveen Dabas | 2018-08-27 06:03:02 | Re: pg_sample |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Łukasz Jarych | 2018-08-27 08:49:05 | Re: Connection to PostgreSQL from Excel |
| Previous Message | Brandon Hsu | 2018-08-16 10:09:04 | I can not find complete documentation pages from PostgreSQL ODBC Homepage |