Shawn,
>But I would like to test the connection first. Is there a way in MM to do this fast versus going the MS way of creating a connection string and trying to open a connection.
That's the way you would do it! Until you actually try to make the connection there's really no way to test if it's valid.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com