Re: Microsoft Project OLE DB Provider
From: WGHayes (hayes_at_nospam99-please.com.au)
Date: 06/24/04
- Next message: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Previous message: Karen: "How to print both tasks and resources"
- In reply to: JackD: "Re: Microsoft Project OLE DB Provider"
- Next in thread: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Reply: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Jun 2004 10:06:30 +0930
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
"JackD" <see sig for details> wrote in message
news:%23qi4XCUWEHA.1152@TK2MSFTNGP09.phx.gbl...
> 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" <hayes@nospam99-please.com.au> wrote in message
> news:40d92f0c@duster.adelaide.on.net...
> > 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.
> >
> >
> >
>
>
- Next message: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Previous message: Karen: "How to print both tasks and resources"
- In reply to: JackD: "Re: Microsoft Project OLE DB Provider"
- Next in thread: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Reply: Rod Gill: "Re: Microsoft Project OLE DB Provider"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
