Setting up Webspeed with IIS 7.5 Windows 7

The following instructions can be used to create a basic setup for OpenEdge (10.2b) Webspeed development.

The information has been gleaned from the following source – Progress Knowledgebase, ProgressTalk.com, The OpenEdge Hive and also the manuals!  Thanks to all who put info online, especially Scott Auge who has posted some very informative videos.

View all registered OCX and DLLs

Now and again I have problems with registered .ocx and .dll files.

I found a program that will display and allow you to edit / register / unregister the files.

It’s called RegDllView and you can find it here. http://www.nirsoft.net/utils/registered_dll_view.html

Remember to run it as an Administrator if you’re using Windows 7.

Progress / OpenEdge 10.x License Update

When attempting to update the license details the installer checks for already running instances of Progress… but finds itself and stops!

To stop this change the startup target on the Update Icon from:

c:installationdirsetup.exe -u

to

c:installationdirsetup.exe u

Checking a Progress / OpenEdge Database for MSSQL conversion

When I’m converting an OpenEdge database to a MS SQL database there are a few issues to consider.

One important one is that natice OE databases allow users to “overfill” database fields e.g. if I have a field called employee.name defined as CHARACTER FORMAT “x(20)” but have a name which is 30 characters then that is no problem.

In MSSQL however, that will fail.

So when we convert our database Progress supply “dbtool” which trawls through the content of each field checking for overfilling.  It will report the fields then ask to change the internal SQL Width value which I then use when migrating the database.

Unfortunately this tool doesn’t handle database array fields so I’ve amended that procedure and posted it below for reference.

/* Program to Verify / Change SQL Width Sizes within a Progress

database.

This program should be run BEFORE any Schema Migration …

Updating a Progress and MSSQL database

When migrating a Progress database to a MSSQL database I use the following parameters…

I connect to the database using a differing logical name.  Because our apps are compiled using the logical name of the database we need to supply this logical name to the Schema Holder.

Progress / OpenEdge Incremental df

When you want to create an incremental df between two databases you should;

connect to the newer database (appdb)
connect to the older database with diff logical name (oldappdb)
ensure the current working database is the newer (appdb)
create the incremental db from there

Job done!  test