这个SDK到底是什么东西啊,就提供了一个数据库连接工具么?直接用ADO连接SQL server有什么不同 ?cxK~Y\
[<I
`slK
下面的连接为什么连不上呢,连接字符串有什么问题吗?先谢过了 ;GEu.PdxB
-"tgEC\tD
<package> :NyE d<'
~"YNG?Rre
<Job id="getProjectCount"> ?B!ZqJ#
<Script language ="JScript"> ASU\O3%%
{mitF
//create ADO connection object... T1di$8
? UDvFQ&
var cn = new ActiveXObject("ADODB.Connection"); vj$
6
RUtS_Z&
//open connection... #iDFGkK/
BT#g?=n#`
cn.Open("DSN=Primavera SDK;UID=pubuser;PWD=pubuser"); #Kr.!uD
<5}du9 @
var NumRecAff; f)P/@rh
Y6PA\7Y\
var adCmdUnknown = 8; //ado constant v('d H"Y
1*CWHs
//execute SQL command… B9-[wg#0G
*
XGBym
var rs = cn.execute("SELECT COUNT(*) FROM PROJWBS WHERE NODE_TYPE='PROJECT'",NumRecAff,adCmdUnknown); {3Wc<&D
C1
mnjA8@1
WScript.echo("Project Count: " + rs.Fields.Item(0).Value); ljON_*
`{_PSzM
2H "iN[2A
;VRR=p%,
rs.Close(); c10).zZ
jsQ$.)nO
rs = null; =7,UqMl_
/D+$|kmW]
~Xw?>&
TMsoQ82
cn.Close(); MT0{hsuK9
IBh~(6
cn = null; uJ[Vv4N%9
j56 An6g
Am
$L
/)TEx}wk
</Script> N
kI:
-+_twU
</Job> @D=`iG%
5zOSb$;
</package> m)}MkC-
G-
WJlu