Microsoft Project 2002 OLE DB Provider

[Greta]

Please help:

I've developed an application that uses Microsoft Project
2002 OLE DB Provider and VB6. Now I have to deploy it to
the client site but the client doesn't have Microsoft
Project installed on the required PCs.

Is there a way to get just the Microsoft Project 2002 OLE
DB Provider without the need to install Microsoft
Project ? Does Microsoft provides this driver freely?
If not is there other way to connect to Microsoft Project?

Many,Many Thanks !!
Greta

 

[Shane]

I searched for many days for that very thing and was unable to find anywhere where one could simply download a particular OLE DB provider. If you find such a place, I would love to know where it is.

 

[Ijaz Rasheed]

Hi Greta:

I am trying to make connection with MS Project 2003
from one of my ASP file but it gives the following error

Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly
installed

Now i beleive that i need MS Project 2003 OLEDB Driver
ver. 9.0 or 10.0 so can you help me out in this regard.
I am using the following code for MS Project connection.

myConn.Open "Provider=Microsoft.Project.OLEDB.9.0;" & _
"Project Name=c:\projectguide\sample.mpp"

So now from where i can downlaod this driver to go to
next step.Can anybody guide me? Earliest response would
be highly appreciated from my side.

Regards,

-Ijaz

 

[Shane]

When you install MS Project on a computer, it automatically installs the provider. For 2002 it is OLEDB.10.0. For 2003 it is OLEDB.11.

Maybe all you need to do is change the version number in your code from 9.0 to 11.0.

 

[Rod Gill]

Hi,

Search your Project program folders for prjoledb.htm. It has a description
and examples.

--
For VBA posts, please use the public.project.developer group.
For any version of Project use public.project
For any version of Project Server use public. project.server

Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.projectlearning.com/

When you install MS Project on a computer, it automatically installs the

provider. For 2002 it is OLEDB.10.0. For 2003 it is OLEDB.11.0

Maybe all you need to do is change the version number in your code from

9.0 to 11.0.