I posted this response to a similar problem in another forum:
In DOS mode, run MEM /C to see if MSCDEX is displayed in the list of drivers. If it is not, your MSCDEX.EXE file may be corrupt, missing, or improperly syntaxed in either the CONFIG.SYS or AUTOEXEC.BAT file. Be sure the /D switch is identical for the low-level driver and MSCDEX.
If MSCDEX is listed in MEM, look to your hardware. Has the location of the connection been changed--that is, was it connected to an IDE connector and now to the sound card or vice versa? Be sure the ribbon (signal) cable is securely fastened and not reversed on the connector and the Molex connector is also securely fastened (does the power light come on during POST?). Also, the ribbon cable itself may be bad; try it with another cable.
Other suggestions: Go into CMOS and run "Auto Detect" for HDDs, if you haven't already. Enter "device=[path]\setver.exe" into CONFIG.SYS. Although DOS should not require it if you have later than 5.0, it has been known to make a difference for some reason. Also, if you have a "lastdrive=[x]" command there, be sure the specified letter is beyond that the CD-ROM is supposed to specify.
There is an outside chance the drive controller itself may have gone bad. If you have it plugged into a connector on the MB, change it to the sound card if it has an accomodation for it (or vice versa). If you hook it to the sound card, run a hardware search in Windows to install it through the SC drivers. You may have to go to the Creative web site to see if they have an driver installation file to enable it in DOS (or even Windows).
Hope you find some help in here. Good luck!