Providers to use when connecting to MS Project
» Microsoft Project 2003 OLE DB
» Microsoft Project 2002 OLE DB
» Microsoft Project 2000 OLE DB
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» Microsoft Project 2002 OLE DB
» Microsoft Project 2000 OLE DB
» .NET Framework Data Provider for OLE DB (OleDbConnection)
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
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
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
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
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;