asked on

Where can I find Microsoft Project OLEDB driver (9.0 or 10.0)

Can anyone tell me where to download the oledb driver for Microsoft Project 2000? Specifically, I'm writing an application in C++ using ADO / OLEDB. I'm using provider string of "Provider=Microsoft.Project.OLEDB.9.0; Project Name=c:\\somefile.mpp". I have MDAC 2.8 load on my XP (pro, sp1) computer, but for the life of me I can't locate a Microsoft Project OLEDB driver.

I've searched Microsoft.com to death.

Thanks,

rockiroads

there normally held where you installed Microsoft Office

e.g.

C:\Program Files\Microsoft Office\Office

nasoco

ASKER

I appreciate the info, but I don't know which files are for the OLEDB provider for Project. There are 442 files (including subdirectories) in my Office directory.

Thanks,

Arthur_Wood

Actually, you probably want to use the Provider=Microsoft.JET.OLEDB.4.0 (there is not a separate Provider for Project). Then you specify the DataSource as the Project file:

connection string would look like:

"Provider=Microsoft.JET.OLEDB.4.0; DataSource=c:\somefile.mpp"

I am reasonably sure that that should work, though I do not have Project on this machine, so I can't test it to be certain.

There is NOT a 9.0 version of the OLEDB data provider, the newest version is the JET.OLeDB.4.0 provider.

AW

nasoco

ASKER

Sorry, the mpp file format is not readable with the JET engine. I already tried that. All the info that I'm getting from my searches is telling me to use the above mentioned provider string. I just can't figure out what files constitute the Microsoft.Project.OLEDB.9.0 package.

Thanks,

ASKER CERTIFIED SOLUTION

Alan Warren

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nasoco

ASKER

Alan,

Thanks for the info. That's exactly what I was looking for. I appreciate your thorough explanation of each item.

Thanks,

Nasoco

NIKALogic

I just downloaded MS Project 2003 trial to try and get to the files you are mentioning above. However, the files you are mentioning are not there. I have exact same problem - I need to be able to retrieve data from .mpp file. Could you advise on alternatives I may have to do this?

Biniamal

Hi Nasoco,

Have you found the answer for your problem. We are having the same problem. If you have found the answer, please post it.

Bini

lsdillard

After much searching myself, I found the files in the locale directory within office.
..pfiles/Microsoft Office/OFFICE11/1033/PJOLEDB.HTM
..pfiles/Microsoft Office/OFFICE11/1033/PJDB.HTM