PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Can a PostgreSQL file be opened directly in PxPlus?  (Read 1251 times)

bmohrhardt

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
Can a PostgreSQL file be opened directly in PxPlus?
« on: February 13, 2020, 02:04:27 PM »
Hello Forum :

        If a PostgreSQL file cannot be OPENed directly, are there any plans to add the possibility?

        Thanks,
        Bill.

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Can a PostgreSQL file be opened directly in PxPlus?
« Reply #1 on: February 13, 2020, 02:13:24 PM »
You should be able to access the PostgreSQL file using ODBC on either Windows or Linux.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com

bmohrhardt

  • Silver Member
  • ***
  • Posts: 23
    • View Profile
Re: Can a PostgreSQL file be opened directly in PxPlus?
« Reply #2 on: February 13, 2020, 04:12:20 PM »
Thanks Mike. Do I have to install the ODBC driver on the Linux server-side? Or is that only required on the Client?

Mike King

  • Diamond Member
  • *****
  • Posts: 3810
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Can a PostgreSQL file be opened directly in PxPlus?
« Reply #3 on: February 13, 2020, 04:38:42 PM »
You would need a unixOdbc driver for PostgreSQL and need to know how to configure it (something I don't know I'm afraid)
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com