No problem that your BIOS doesn't see the burner as a burner. This is just a function of the brand and age of the BIOS. The ATAPI CD ROM messages you are getting are telling you that your BIOS is properly seeing the drive.
For example, I have an old Celeron 366 machine, and my BIOS sees the machine's two burners as "CD-ROM" drives. The burners work fine.
At CDRLabs, they have an FAQ with pictures about how to enable DMA.
What burning software (and what versions) have you tried? Nero supports your drive. You can download a free demo from their site and give it a try.
The fact that the burner is an OEM model has nothing to do with the fact that existing software won't "see" it. In fact, if I remember right, Sony was selling that exact drive in some of their retail packages!
You should be able to use the burner on your system. You may not be able to burn at 48x, but you should be able to do at least 24x. When I say you won't be able to do 48x, I mean that the computer won't keep up with the burner when you burn at 48x, so your burn won't be as fast as it would have been using a faster computer.