Connection strings for MS Project

Project 2007, unlike Project 2003, does not include an OLE DB Provider. To query Project data programmatically, use the Microsoft Office Project Server reporting store or the reporting cubes. The Reporting database is used for read-only, server-side data access. Data access to local .mdb files from Project Standard or Project Professional is accomplished through the VBA object model.

You can also save projects as XML files for access to project data. It is also possible to save your mpp project file in a 2003 format and use the Microsoft.Project.OLEDB.11.0 provider.

Another option is to use the 2003 Microsoft.Project.OLEDB.11.0 provider to connect to the 2007 mpp file. Please note that for this to work service pack 3 for Project 2003 must be installed.

Microsoft Project 2003 OLE DB

Type OLE DB Provider
Usage Provider=Microsoft.Project.OLEDB.11.0
Manufacturer Microsoft

Provider=Microsoft.Project.OLEDB.11.0;Project Name=myProjectDatabaseFile.mpp;

Microsoft Project 2002 OLE DB

Type OLE DB Provider
Usage Provider=Microsoft.Project.OLEDB.10.0
Manufacturer Microsoft

Provider=Microsoft.Project.OLEDB.10.0;Project Name=myProjectDatabaseFile.mpp;

Microsoft Project 2000 OLE DB

Type OLE DB Provider
Usage Provider=Microsoft.Project.OLEDB.9.0
Manufacturer Microsoft

Provider=Microsoft.Project.OLEDB.9.0;Project Name=myProjectDatabaseFile.mpp;

.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft

Use an OLE DB provider from .NET

Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.