OLEDB Provider Problem while opening Project 2000 file

[Vijo]

Hi

I am trying to retrieve details from Project 2000 mpp file. But it is giving
me the following error.

" Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done. "

As mentioned in the microsoft site I have added OLEDB_SERVICES to the
registry. After that I'm getting a different error.

"Non-NULL controlling IUnknown was specified, and either the requested
interface was not IUnknown, or the provider does not support COM aggregation."

Is there any work around please.

Below is my code

OleDbConnection MyConn = new
OleDbConnection("Provider=Microsoft.Project.OLEDB.9.0; Data Source=
E:\\SoftDev.mpp; Extended Properties=Project 9.0;");
OleDbCommand selectCMD = new OleDbCommand("SELECT TaskName from Tasks",
MyConn);
selectCMD.CommandTimeout = 30;
OleDbDataAdapter custDA = new OleDbDataAdapter();
custDA.SelectCommand = selectCMD;
DataSet custDS = new DataSet();
custDA.Fill(custDS, "Tasks");

 

[Rod Gill]

Review the file PRJOLEDB.HTM installed in one of Project's program folders
and try getting what you want running the code from Excel VBA. Then adapt
the code to your system. I see in your code an address of E:\\ Should that
not be E:\