Search Postgresql Archives

Connection to PostgreSQL from Excel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux