How to connect to project server reporting database ?

[ctd]

Hello,
I need to retrieve the list of custom field values from the table
MSPLT_xxxx_UserView in the reporting database, how do I do this ? I have the
"Select ....from..." statament already, but not sure how I make the
connection in my code.

Thanks.

 

[Rod Gill]

Create a recordset to the View (plenty of examples in MSDN) then:
Dim fld as adodb.field

for each fld in myrecordset
debug.print fld.name
next fld

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Hello,
I need to retrieve the list of custom field values from the table
MSPLT_xxxx_UserView in the reporting database, how do I do this ? I have
the
"Select ....from..." statament already, but not sure how I make the
connection in my code.

Thanks.

__________ Information from ESET Smart Security, version of virus
signature database 4950 (20100316) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4950 (20100316) __________

The message was checked by ESET Smart Security.

http://www.eset.com