After years of trying to get this game to play on a Windows XP system, I have finally succeeded!

It involved downloading a wrapper that "JiriDvorak" created and hexediting the main ds9dw.exe file to replace instances of ddraw.dll with the new ddra2.dll wrapper.

I can finally play one of my favorite Star Trek games again. If anyone wants the modded .exe file and the wrapper drop me a pm with your e-mail addy and I'll send it to you.