Stephen,
>I guess I'll just append "PROVIDER=SQLOLEDB;" in front of the connection string and it seems to work. Another question I have is that is it possible to change the connection string programmatically after the user logged in?
You could, but it would require creating a subclass of mmDatabaseManager because the ConnectionStrings property is protected. In what way do you want to change connection string?
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