O4W and Inheritance levels (O4W)
At 13 JUN 2012 09:18:55AM Richard Bright wrote:
Am I correct in assuming that O4W support max 3 levels - that is only 2 inheritance levels below SYSPROG?
Somewhere, back in the mists of time I came across the understanding in OI that inheritance may work beyond 2 levels below SYSPROG but gets risky. Thus my standard design has been -
Sysprog - Common Utilities - Application
Recently -needing to handle possibility of multiply Sites for an O4W application - as a strategy I tried tacking on the Sites as level 4 - to provide a shell to support site specific attached tables ie
Sysprog - Utilities - Application - Site_nn
With this 4 level structure I could not log in to O4W ( 1003 error). O4W works OK at higher inheritance level.
It s not a big problem for me to fold the Utilities parent level into the Application to truncate the inheritance chain - but would like some guidance here.
Regards
Richard Bright
At 18 JUN 2012 05:59PM Richard Bright wrote:
Well it is another case of 'foot in mouth'.
Indeed O4W DOES support the full inheritance chain beyond 3 levels ie more than 3 inheritance levels below SYSPROG.
The clue to my problem was the O4W error code 1003 - which indicated exactly what problem was - refused login. Why - because there was a miss-match of registry UserName + UserPassword combo and OI UserName + Password of the new inherited app. Fix that and all is well - so I now have a possible schema as an alternative to aliasing tables - to test for hosting multiple databases / software as a service.
Richard Bright
At 19 JUN 2012 07:17AM mike ruane wrote:
Richard-
Glad you found and fixed. Are you offering a hosted solution for your customers?
Mike
At 19 JUN 2012 07:58AM Richard Bright wrote:
Hi Mike
<Are you offering a hosted solution for your customers?>
It's real early days - but just exploring possibilities for specific application (Historical Archives) where public - web access search and browse is real valuable, and for which some sites just are unlikely ever to the technology funds etc to do it themselves. Who does the hosting etc is not yet the topic - but rather will this work, can I put together a viable schema; what are the issues to contend with.
Just the sugestion of what can be done and demonstration - clients have become very excited; market possiblities seem to have opened up.
I'm sure other developers will find that re-working their apps - or parts of their apps as web - delivered solutions will open up new markets and enable them to retain customers that might otherwise droped off the list.
Richard