Have you added the ADO reference
Microsoft ActiveX Data Objects 2.8 Library?