OK -- so it wasn't quite obvious. Tuan at Servoy was good enough to step me through this, and a few other things. (Thanks, Tuan!) Here's what I learned. It's a bit terse, but I hope someone else finds this helpful. Normally I would include annotated images with this kind of doc, but I'm on deadline and I need to get back to work.
How to set up a JDBC connection to Progress DB(1) Ensure that you have the "SQL Client Access pro"duct installed on your PC. This is the free ODBC/JDBC driver that Progress supplies. You might have to contact your sales rep to get it. (There is also a more powerful JDBC driver from Progress -- created by DataDirect -- but that's not free.) There are docs in the Progress KnowledgeBase describing how to set this driver up, which I won't reproduce here. I will simply note that you have to start the Progress database server with network access enabled (proserve .... -S <port#> .....)
(2) Start Servoy. On the left, under Resources, right-click on Database Servers. Then select "Connect to existing database" and "Empty". (I have only one Progress entry on the list: "Progress ABL". This is
not what you need for JDBC access. The ABL connection requires a third-party driver, and it apparently allows you to use ABL code as a data source. Cool! But not JDBC. If you see another Progress entry, like "Progress JDBC" on this list, then you can probably use that and ignore the rest of these instructions.)
(3) Enter the Server Name you want to use, and your username/password. Do not enter a URL. [ Progress note: If you have no users defined in your database, then Progress defaults to granting full SQL permissions to the user that created the DB. If you
do have users defined in your database, then you have to grant SQL permissions to them. The Progress KB can point you to more information about this. ]
(4) Click on "Show advanced server settings", which on my system shows up just below the messages telling you to download a driver. Enter the following:
URL: jdbc:datadirect:openedge://<host>:<port#>;databaseName=<yourDatabase>
for instance: jdbc:datadirect:openedge://localhost:42000;databaseName=sports2000
Driver: from the dropdown list, select
com.ddtek.jdbc.openedge.OpenEdgeDriver
Next to Schema, enter
PUB
The rest of this page can remain at default values, or you can tweak things to suit. Try the "Test Connection" button; with luck, you now how a working JDBC connection to Progress.
On the left, under Resources / Database Servers, you should now see your connection. If you click on the arrow to open it up, you should see your tables. Double-clicking one will show you the schema.
------------
Now, to test it. I learned the following from the "Servoy in 5 Minutes video at
https://www.youtube.com/watch?v=2xYLTfDQJLw" video -- constantly pausing and peering at the screen to see what was being clicked on. There's a lot of useful "Getting Started" stuff there, if you have the patience to extract it.
- Right-click on "All Solutions", create a new solution, and give it a name. You can accept the default values.
- Right-click on "Forms" under your new solution, and create a new form.
- Give the form a name.
- Click on the three dots to the right of the DataSource field, and in the drop-down list find your newly created datasource. Pick one of the tables from the DB. Click on Next.
- You should see list of fields. Double-click on two or three fields to add them to the form. Click on OK.
- On the top of the screen, just under the menu, are some icons. The fourth from the left (at least on my system) is a little rocket ship which launches the NG client. Double-click on that. You should see a simple page with a vertical slider, allowing you to look at your data.
Good luck to all.