If you usually use DSN-less connections with ADO, you know it can sometimes be a pain to figure out the correct connect string. In that case, you can let the VB Data Environment do the work. Start a dummy project, bring up the Data View windows, and connect to the database you’re interested in. Add a Data Environment to the project and drag a table to it. Press F4 on the connection to bring up the properties for the connection. The ConnectionSource property then has the connection string you need.