>Hence, I've been wondering what do I need to do to automate hdsploader as soon
> as the cardbus has been connected?

using the new modprobe.conf syntax ....

install snd-hdsp /sbin/modprobe --first-time --ignore-install snd-hdsp && { /usr/bin/hdsploader; }
