We help IT Professionals succeed at work.

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

nasoco
nasoco asked
on
Medium Priority
2,946 Views
Last Modified: 2007-12-19
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,
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2006

Commented:
there normally held where you installed Microsoft Office

e.g.

C:\Program Files\Microsoft Office\Office

Author

Commented:
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,
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

Author

Commented:
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,
Applications Developer
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Alan,

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

Thanks,

Nasoco
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?

Commented:
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
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.