In the Documentation: http://support.smartbear.com/viewarticle/28454/ it states that you can use :It can be used to execute only SQL queries ( SELECT, UPDATE, INSERT , etc.), But I can't ...
I have not had the TC wrappers for ADO work consistently well. If I were you, I would use CreateObject and address the ADO objects directly. Google ADO reference for details.