I missed your messages. Sorry for the late reply. I installed the APM a few times and haven't experienced your symptoms; though, the OS was Linux. Any ideas as to why create.sql gave you a problem the first time around?
Thanks for the reply. Unfortunately I don't know why the "-create.sql" file wasn't run properly. I will look into that when I am back in the office (today, monday, is a holiday here in the Netherlands).
The good thing is that it runs perfectly after loading the datamodel. I haven't had time to look more in details into it but I think I will have to as we are having some talks of using SOAP to communicate between some databases and our OpenACS installation... I managed to debug some SOAP messages with XML-SPY so that worked nicely. Generated some simple messages as well with Java (Apache AXIS and JAXP as well).... so this shouldn't be too complicated :)