Connection to PostgreSQL from Excel

Поиск
Список
Период
Сортировка
От Paul Suworow
Тема Connection to PostgreSQL from Excel
Дата
Msg-id -3a5719ao6eou3leql-edduop-bzcl2t4oi9cm-fxcuey-a4i1c4-jsfglwfhie6bdtabdc-bxwmcnqe0xk7-q0nc5o-n3nir5-dkdwdbkihg1i2s8mhd78g4i3-onf2e0w2oio4nnlmvd-n3k13z-1j3goc.1535355997668@email.android.com
обсуждение исходный текст
Список pgsql-general
Hi team,

I am working on an Excel tool that should allow users to update tables and charts from a PostgreSQL database. My
workbookcurrently 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Naveen Dabas
Дата:
Сообщение: Re: pg_sample
Следующее
От: Łukasz Jarych
Дата:
Сообщение: Re: Connection to PostgreSQL from Excel