I've been having a "Connection" error when trying a simple SQL "CREATE VIEW". One response here pointed out that CREATE VIEW was an ADO feature. When I tried ADODB, etc I always got a Connection Error.
For several weeks I've been getting random(?) "...can't find IUMG..." notices...I googled, found several articles. I'd put the ISP here but it's so long I'm sure I'd misspell...so GOOGLE and look for "How do I Repair a missing...." By John Barnett. Be prepared for several restarts.. Download the TWO files indicated! to a new folder and be sure the folder is where DOS (!!!) can find it! Be prepared for at least 2 restarts. Choose restart in Command mode, so's you can find the downloaded files. You execute the MDAC first, restart (!) run the jet 4 program, RESTART!! and away you go!

Now my ADO's (so far) work!