这个SDK到底是什么东西啊,就提供了一个数据库连接工具么?直接用ADO连接SQL server有什么不同 Tl L\&n.$
}.r)
下面的连接为什么连不上呢,连接字符串有什么问题吗?先谢过了 m;{(U Z
;! ,I1{`
<package> C=x70Y/
vf?Xt
<Job id="getProjectCount">
P1dFoQz
<Script language ="JScript"> [E)&dl_k
`Ln1g@
//create ADO connection object... SS!b`
He1~27+99
var cn = new ActiveXObject("ADODB.Connection"); BMItHn].
Qq3>Xv <
//open connection... )0zg1z
tY%T
cn.Open("DSN=Primavera SDK;UID=pubuser;PWD=pubuser"); e,
}{$HStZ
uTNy{RBD+
var NumRecAff; &Xi]0\M)
%e+{wU}w?2
var adCmdUnknown = 8; //ado constant ce7$#
# f
EOXuc9>
G
//execute SQL command… 85BB{T;
th}&|Y)T2
var rs = cn.execute("SELECT COUNT(*) FROM PROJWBS WHERE NODE_TYPE='PROJECT'",NumRecAff,adCmdUnknown); _7<G6q2(
?MOjtAG0_~
WScript.echo("Project Count: " + rs.Fields.Item(0).Value); X0 ]Se(
}ISR +./+
jQ['f\R
B C R]K
rs.Close(); DTl&V|h$
! q+>'Mt
rs = null; c*",AZ>U
?ZYj5[op,H
)h1 `?q:5
|WSmpuf
cn.Close(); [6)vD
@
@%!Gj{
cn = null; ([]\7}+8
R)Dh; XA
S"/gZfxer
4MRN{W6
</Script> CJ [e^K{
`[~LMV&2U
</Job> A+VzpJ~
}D
Q[C&
</package> *}Rd%'
Hnf?`j>