Connection strings for MS Project
Providers for MS Project
Community Forums
Find solutions and post questions regarding connection string related issues.
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.
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
Usage: Provider=Microsoft.Project.OLEDB.11.0
Manufacturer: Microsoft
Customize string example values »
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
Usage: Provider=Microsoft.Project.OLEDB.10.0
Manufacturer: Microsoft
Customize string example values »
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
Usage: Provider=Microsoft.Project.OLEDB.9.0
Manufacturer: Microsoft
Customize string example values »
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
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
Bridging to Project 2003 OLE DB
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.Project.OLEDB.11.0;Project Name=myProjectDatabaseFile.mpp;
Selected Articles