I am migrating an old asp application, with a VB5 MTS component and Oracle 8 database, from NT to a Win 2003 server (IIS v6.0), and it is proving problematic. I do not have the original source code, nor any documentation (none at all) for the component, so I don't have much to work on.
I am using Visual Web Developer 2008, and have registered the dll in Component Services and added the reference to the COM in the web project (just copied all the files from the old server to the new server). I have also set up the website in IIS with the same parameters. I created a test .asp page, similar to the home page of the asp so that I can test the calls individually to find out where it is breaking down.
It appears to successfully create one of the class objects as the err.number = 0 after the call to create the object, however, when I try to get the object to do something, it returns error number 424 - Object required, so I am unsure if it is actually getting created properly. The object is meant to be creating a connection to a database (system registered DSN - I can successfully connect via Oracle SQL+) and querying a table to see if I have been setup to use the system (using OS username). If I have been setup, then it should display a list of pages that I am allowed to see, otherwise it should return the local error.asp with the correct error message (i.e. "You have not been setup to use the system." - I expect to get this message).
Has anybody experienced this sort of problem when migrating an asp site from NT to Win2003? Can you offer any pointers as to what other things I should be checking? Any ideas as to how I can get this to work?