*In order to make PostgreSQL work with our products, two things must be done: 1. Install and configure the PostgreSQL ODBC drivers, and 2. enable SQL mode for the ODBC driver.
1. Download the full PostgreSQL ODBC installer from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads and install it on the machine with Labelview. You must create a new local admin account called "postgres" and then run the installer file as that user (shift+rightclick on the installer file, select "run as...", and enter the new postgres user credentials you created).
In the installer, make sure all the checkboxes for installable features are checked (they should be by default), create a password for the postgres user (pass: Teklynx! ), and choose the default port (5432).
After the installer has finished, launch the Stack Builder from Start>All Programs>PostgreSQL xx>Application Stack Builder. This will ask you to install add-ons. Select the database you created at installation, then in the next screen expand Database Drivers, and select the psqlODBC (32-bit).
2. To enable SQL mode for the ODBC driver, copy all the files in "F:\Operations\Tech Support\Patches\ODBC SQL Enabler" into the installation directory (C:\Program Files (x86)\Teklynx\Labelview [or similar]\ ), overwriting all files when prompted.
Launch LABELVIEW and create a new database using the wizard via Data Sources > Database > Create/Edit query, then click New and then Wizard. Choose ODBC and then Finish. Click Add in the new window, then select PostgreSQL ODBC Driver (UNICODE). Then, in the configuration window that opens, the fields are as follows:
Database: The name of the database. The default is postgres but the administrator may have chosen another one.
Server: Which machine the database is on, by IP or hostname.
Username: The username of a database account with full access to the database/table in question.
Port: 5432, unless customized.
Password: The password for the database account you entered above.
Confirm all open dialogues, then proceed to configure the connection as normal.