PowerBuilder Connect PostgreSQL Using ODBC

PowerBuilder Connect PostgreSQL Using ODBC

Step 1: Get driver ODBC Postgresql psqlodbc35w.dll from page : https://www.postgresql.org/ftp/odbc/versions/msi/
Step 2: Registry Regedit With Run file .Reg or PowerBuilder Function RegistrySet()
Step 3: Test Connect

PowerBuilder Connect Postgresql
PowerBuilder Connect Postgresql

Find Projects On Github click here

Good Luck!

Was this article helpful?

Related Articles

6 Comments

    1. you can use it directly using PROVIDERSTRING. I’m going to ODBC using DNS instead of having to register by myself, I set by code. If you use dns you don’t need to install driver, just library.dll driver can work. If you use PROVIDERSTRING you are required to install the client driver. This will be easily deployed to the client machine

  1. Alex Rodrigues

    Have you used the functions of PostgreSQL, LO_Export and LO_Import in a client / server application? When running Lo_export for example, it looks like the file is being created on the server and not on the client machine.
    Do you know how to fix this?

    1. I use psql and run normally you can refer to it.
      “psql.exe” -h 192.168.1.1 -p 5432 -d mDB -U madmin -c “\lo_export 19135 ‘C://leeImage.png’ “;

      h 192.168.1.1 : is the server system IP
      -d mDB : the database name
      -U madmin : user name
      \lo_export : the export function that will create the image at the client system location
      C://leeImage.png : The location and the name of the target image from the OID of the image
      19135 : this is the OID of the image in you table.

Leave A Comment?