Microsoft Project OLE DB Provider

[WGHayes]

Is it possible to install the OLE DB provider for MS Project (either 9.0 or
10.0 - aka Project 2000 or Project 2002) without having Microsoft Project
installed on the computer wishing to use the provider?

I have MS Project data stored in SQL Server 2000 data schema, therefore,
there is no particular need for ALL workstations/PC clients to have MS
Project installed.

Is this possible or is this a restriction? (i.e. does the OLE DB provider
actually call through MS Project?)

Thanks,
WGH.

 

[JackD]

The file called prjoledb.htm has documentation on the OLEDB provider.
You can find it on your hd or project cd.
It says:

"To view data access pages on a local provider, you need to use Microsoft
Access 2000 or 2002 along with Microsoft Project installed on the computer
viewing the provider. Microsoft Project automatically installs the OLE DB
Provider, any international .dll, the appropriate registry keys, and any
needed ActiveX controls."

So yes, it does look like project is required and I am not sure of a way to
install the necessary parts of project without installing the whole thing. I
would expect it violates the EULA anyway.

However if the project data is stored in SQL server then you don't neet the
OLE DB provider.
A simple ODBC connection to the database will be sufficient.

-Jack

 

[WGHayes]

Thanks JackD for the help.

The only reason I would like to use the OLEDB provider for MS project is to
gain access to a Timephased Data by Task, Assignment and Resource at a
Week/Day/Hour level (the provider is ideal for this purpose as it presents
the data in exactly the format I require). I already use an ODBC connection
to view the MSP_* tables in SQL Server however attempting to unravel the
MSP_TIMEPHASED_DATA into a timephased view is not that obvious. Ideally I
would have preferred to use ODBC for everything but it was not possible for
the timephasing requirement.

This makes deployment of our solution 'reliant' on MS Project being
installed on the clients PC/Workstation for the 'one part' of the
application that shows the timephased data. If I could have somehow used
the PROVIDER without having MS Project installed then this would not have
been an issue.

Any suggestions?

Thanks,
WGH

 

[Rod Gill]

How timely does the data need to be? If weekly updates are fine, why not
have a single workstation read all time phased data into a new table and so
make it available to others via ODBC. You could always run this copy
nightly.

--
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/