hii
in the SQL Server CD, there will be a MDAC exe file try running that first.if not try and upgrade to the latest MDAC version 6.0. else try a reinstall of SQL Server. This problem may arise if u install Visual Studio and SQL Server in improper sequence