The compilation error could happen if you have not imported ADODB.
Try adding this (at the beginning):
I think you also need to set reference to MS ADO objects 2.7 library using Project->Add Reference menu item and then select COM tab.
Once you do this, ADO objects are available and you should be able to see ADODB namespace.
Hope this helps.