For a project at OneTwo I needed ADODB instead of ODBC to connect to a database. Realbasic/Xojo can do this through the OLEObject, but non of the methods or properties are exposed to the programmer. If you only need it now and then that’s not a real problem, but in some cases you’ll use it all the time. So I decided to write a wrapper around the OLEObjects to make it easier. Also, all available Enums are available (ADOConstants).
You can download the classes from: http://alwaysbusycorner.wordpress.com/2013/10/17/realbasicxojo-an-adodb-wrapper-around-the-oleobject-framework/