Configuring ODBC data source with PostgreSQL demo
database
To set up the ODBC data source with the PostgreSQL demo
database,
-
Install PostgreSQL 12 and PostgreSQL ODBC driver (both
32-bit and 64-bit).Make sure the Command Line
Tools component is selected during the PostgreSQL 12
installation. -
Restore the PostgreSQL demo database file. For
example,1"C:Program FilesPostgreSQL12inpg_restore" --host=127.0.0.1 --port=5432 --username="postgres" --clean --if-exists --dbname=PBDemo --verbose "C:DBpbpostgres2022.dmp" -
Create the ODBC data source that includes the following
settings.Data Source: PB Postgres V2022R2
Database: PBDemo
Server: [IP address for the database]
Username: [user name for the database, postgres, by
default]Port: [port number for the database, 5432, by
default]Password: [password for the database, postgres, for
example]
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest