March 13, 2002 at 3:25 pm
I have finished writeing an ActiveX Control that uses DTS to move data from a Transoft ODBC to an SQL 2000 Server using multiple companies. The problem that I am having is that the DLL works fine in 2000 or XP but crashes after one execution when run on NT4. Does anyone know why this happens?
March 13, 2002 at 7:02 pm
You will need to rebuild it on the NT4 server in debug mode so you can get an idea of why. Most likely you called some other com object that is not installed on the NT4 server. Try checking the dependencies of the dll and see if there is anything specific. Or you could possibly not have done some cleanup process in the dll code before the next iteration that 2000 and XP do to it on there own (this is most likely not the answer but is possible).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 19, 2002 at 9:07 am
That is not the issue. We attempted to build the DLL on an NT4 Workstation and it did not work. Using the dependency walker only revealed that the list of dependencys are identical. As far as code cleanup. The objects are completely uninitialized and destroyed before moving on to the next iteration. I am able to say this with confidence after checking 3 times to make sure. After doing some reading I found the solution which is to include two other librarys from DTS into the DLL before compiling it. (Custom Tasks Library and the DataPump Scripting Objects). For some reason (albeit that there are LOTS of custom VBScripts in these packages) they run fine in XP or 2000. But when these libraries are not included in NT4 they crash (as should be expected). However thank you for your input. Making me double check my dependencies gave me the idea of reading more into the requirements of using custom transformation scripts. Considering that they ran fine on the development platform (XP) I would have never guessed that the other two libraries were required to use the custom transformation scripts on NT 4.
March 19, 2002 at 9:51 am
Glad to hear you found your answer. I will have to keep this in mind next time someone has a similar issue.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply