You should add some error checking (@error, @serror) after the USE statements and check the results. This will give you a better idea of why the drive is not mapping. Writing this information to a logfile would give you the ability to review the results.
