TechNet Event Session

1
????????????????????????
2
TNQ400-11
???? ???????????????????????????
3
???? ???????????????????????????
lt??gt??Microsoft
4
????????

• ?????????????????
• Windows 2000 ?????
• ??? Project ??
• ??? SQL Server ???
• Active Server Page (???????)?Active-X ???? HTML
  ??
• ??????? 200 ?

5
?????????

• ????? Project 2000 ? Project Central ???(????
  Project Central ?????)?
• ?? Project Central ??????
• ??? Project 2000 ??? Project Central ?????????

6
?????????

• ?? SQL Server 7.0 ?????????? Windows 2000
  ?????,???????????????
• ?? Microsoft Project 2000 ?????????? VB
  ??,??????????(KM)?????

7
?????????

• ?? ADO ????????????????????????
• ?? Microsoft Project Central ASP? Active-X ???

8
??????
0

• Project Central ? Project 2000 ??

12
22

• ????? Ignite ???????

• Project 2000 / Project Central ?????

• Ignite ?????????

• ????,???????????????????

90
9
Project 2000??

• Project 2000 ?Microsoft Project (CPM ??)?????

Project 98 ??????
???? ????
Project 2000 ?????? ????
10
Project Central??

• Project Central ? Project 2000 ? web ?????
• ??Project 2000????
• ???????/??
• ?????
• ????
• ????????????

11
???? Ignite ?????

• ?????????????
• ?? KM ?????????????
• ?????????

12
Ignite ???????

• ????????????????????????
• ?????????????
• ???????????
• ????????????

13
Project 2000 ?????
Project 2000
Project 2000 ODBC
DSN
14
Project Central ?????
PROJECT CENTRAL
Internet Explorer 5 Or Project Central Client
IIS (w/RDS)
ASP (98 Jscript)
ISAPI ????
Grid Control ActiveX

• Project Central
• SQL 7.0
• MSDE
• ORACLE

COM Components
Project 2000
Project 2000 OLE DB
DSN
Project 2000 ODBC
DSN
15
Ignite ?????????
Ignite Launch Info SQL 7
Ignite
Ignite ActiveX ??
PROJECT CENTRAL
Internet Explorer 5 ?? Project Central ?????
ASP (98 Jscript)
IIS (w/RDS)
ISAPI ????
Grid Control ActiveX

• Project Central
• SQL 7.0
• MSDE
• ORACLE

COM ??
Project 2000
Ignite Macros
Project 2000 OLE DB
DSN
Project 2000 ODBC
DSN
16
Ignite ?????

• Windows 2000 ?????
• ????
• Project 2000
• ??????
• Project Central
• ?? Web ????

17
Pop Quiz (Ignite ???)

• Ignite ???????????

? ?? Web ???

• ????????????

• Netscape

• Mosaic

• Gopher

• Internet Explorer 5

? IE 5
18
?? Project Central ????

• ??
• SQL, MSDE, ?????? Oracle DB
• Internet Information Server 4.0 ?????
• ???????? DB create ??(???c\ProjectCentral\isapi\1
  033 ?)
• SQL Server 7.0
• CRTTABLE.SQL
• INSDEFSQ.SQL
• INSDEFSI.SQL
• Oracle
• CRTTBLOR.SQL
• INSDEFOR.SQL
• INSDEFOI.SQL
• ???????,????5??

19
?? Project Central ??

• ???? / ??
• ???????????
• HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\
  MS Project\WebClient Server\ProjectCentral
• "Provider""sqloledb"
• "QueryFileStd""C\\ProjectCentral\\isapi\\QueryLi
  bStd.sql"
• "QueryFileExt""C\\ProjectCentral\\isapi\\QueryLi
  bSQL.sql"
• "UserName""ignite"
• "Password""ignite"
• "ConnectString""Data SourceseatrendInitial
  CatalogIgnite_ProjectCentral"
• ????? 24 ?????? Project Central ???????????????
• file///C/ProjectCentral/Help/1033/SVRSETUP.HTMM
  ultipleSites
• ?? ?? Web ?? IIS ???????
• ? ???? ProjectCentral ?? Web? ????????????
  Web,????????????

20
????????????
21
Project Central????

• Project Central ??
• ?????
• ???
• ??

??
??
??

• ????
• ?? NT ??
• ?? Project Central ??
• ????

??
?? ??? MSPJCOMM.DLL ?? Project 2000
???????????????????????????????(????),??,????????
Project Central ?????????,????????????????Project
Central ????
22
Project Central / Ignite??
23
?? Project Central
24
?? Project 2000 SQL ??????

• Project ??????
• Project Central ??????

25
????

• ?????
• RAID 0 (??????????)
• RAID 5 (??????????)
• RAID 0/1 (????)

26
RAID ???
RAID 0 RAID 1 RAID 5
?? ?? ? ??
?? ?? ? ?
?? ?? ?? ?
?? ?????? ????? ??? ??????? ?????????? ?????? ????????????????? ?????
27
Ignite ?? ????
IgniteSQL70
???????
??? RAID 5 ??
5 Gig
5 Gig
5 Gig
5 Gig
5 Gig
4 Gig
4 Gig
4 Gig
4 Gig
4 Gig
C 2 Gig ??
E 8 Gig Ignite ??? ?????
????
D 2 Gig ??
????
28
Ignite ???????

• SQL 7.0 ??????
• ????
• ?????
• ????????
• ????

29
?? Ignite ???

• Project 2000 ????? Project Central ???????????
• ??100??????
• ???? Windows 2000
• ??4????
• ??????????????????????

30
SQL 7.0 ???????

• ADSI OLEDB ?? SQL ??
• SELECT FROM OpenQuery( ADSI, 'SELECT name,
  manager, adsPath FROM ''LDAP//CNUsers,
  DCStreetMarket,DCNET'' WHERE objectCategory
  ''Person'' AND objectClass ''user''')
• ADSI OLEDB ?? LDAP ??
• SELECT FROM OpenQuery(ADSI,'ltLDAP//CNusers
  DC StreetMarketDCNETgt((objectCategoryPerson)
  (objectClassuser))name, manager,adspathsubtree'
  )

31
Project 2000 ??????????????????

• Project 2000 ??????
• Email
• Web
• Project Central ???????????
• ? Project ?? Web
• TeamAssign
• TeamUpdate
• TeamStatus

32
??????
33
??? (Team Status)

• ????????????????????????

• ??? Project Central ?? Team Status ?? Project
  2000 ??Team Status ?

? Project Central
34
??????

• Ignite ???????????
• ??????
• ????
• ?Project 2000 ??? web ??
• ???? VB/VBScript ?????????
• ??
• ????

?? ????????????????????
35
????????? Project ????

• ????????
• ????
• ????

36
Project 2000 ????????????

• Ignite ????
• ???????
• ????????????
• ????????
• ??????

37
???? ????

• ???????????????
• ???????????????????????????
• ???????????

38
???? ????

• SHAPE parent-sql-command AS name
  APPEND (child-sql-command AS Name RELATE
  parent-field TO child-field )

• ?? DHTML DIV ???????,??
• ??????????????

39
???? ??

• ? Provider ????? MSDataShape?
• ?? ADO ?????????? SQL ?????

Subcat_id Subcat_desc
Subcat_id View_id View_Name
rsViews
40
?????

• ??? TechNet ??www.microsoft.com/technet/
• Microsoft ????
• www.microsoft.com/train_cert/
• ????? Windows 2000 ???????
• www.microsoft.com/TechNet/win2000
• ??????? IT ???????
• www.microsoft.com/technet/usergroup/default.asp

41
??
42
??

• ??Todd Rooke, Dave Fischer, Brandon Thornton
• ???/??Ken Kubota
• ?? Microsoft ??????????,????????????
• Christodolous Papaphotis
• Nis Bank Lorensen