Welcome to LQ!
By "the CD" I assume you mean the CD that came with the adapter? If so, its no surprise, since from my experience vendors usually only supply Windoze drivers on their CD's. First hit on google searching 'ubuntu driver for wusb54g' gives this
(start at post #7). Should be what you need, but feel free to ask if you have any further problems.
EDIT: Realized that this link is kinda old, but looks like it should work. Again, ask if you run into further trouble.