Page Comparison

...

Postgres uses port 5432, so the source port is 9738 (this port will be used when configuring the ODBC connection later) and the destination port is localhost:5432.

Make sure to save this configuration so you can load it later.

Configure ODBC Connection

The Access Application is configured to use a DSN named SELV32.  So, we need to create that DSN using a postgres driver and the port we just created.

1. Control->Panel search for ODBC and choose "Set up ODBC data sources (32-bit)"
2. Select the SystemDSN tab and choose Add...
3. Select the PostgreSQL Unicode driver
4. Enter the following
   1. Data Source: SELV32
   2. Database: open_lmis
   3. Server: localhost
   4. User Name: postgres
   5. SSL Mode: prefer
   6. Port: 9738 (the port we entered into PuTTY)
   7. Password: p@ssw0rd
      Image Added
   8. Save

Your ODBC connection is now setup.

Run SELVeditor

The actual SELVeditor tool is an Access Database configured to connect to the open_lmis database and manipulate the data collection tables.  You only have to configure everyone once, so running it is simpler.

1. Run PuTTY
   1. Select the correct configuration that you saved above.
   2. Select Open