这个SDK到底是什么东西啊,就提供了一个数据库连接工具么?直接用ADO连接SQL server有什么不同 fc%xS7&
] =xE
下面的连接为什么连不上呢,连接字符串有什么问题吗?先谢过了 z(e xA
/vde2.|
<package> Av$^
z8~NZ;A
<Job id="getProjectCount"> .hP D$o
<Script language ="JScript"> Zq|I,l0+E
!t%j?\f
//create ADO connection object... b#Z{{eLny
6BHXp#
#z
var cn = new ActiveXObject("ADODB.Connection"); vNY{j7l/W
n Fg~< $d
//open connection... E7 Ul;d
p8H'{f\G
cn.Open("DSN=Primavera SDK;UID=pubuser;PWD=pubuser"); @* jz
o
uaGk6S
var NumRecAff; ;Ax
}KN7
%2/EaaR
var adCmdUnknown = 8; //ado constant 6V:U(g
'8.r-`l(
//execute SQL command… #7$
H
E *6Cw
l
var rs = cn.execute("SELECT COUNT(*) FROM PROJWBS WHERE NODE_TYPE='PROJECT'",NumRecAff,adCmdUnknown); <QAFL uey
|t&>5HM
WScript.echo("Project Count: " + rs.Fields.Item(0).Value); K.nHii
n;C
:0
f#"J]p
n)e
6>R;
rs.Close(); l^-];|Y
!bx;Ta.
rs = null; x7w4[QYw
t]g-CW3
c?*=|}N
KVaiugQ
cn.Close(); vjCu4+w($Z
$am$EU?s
cn = null; :zbQD8jv
(vnAbR#e
I@~QV@U
J#(LlCs?@c
</Script> RFc v^Xf
|O+H[;TB6
</Job> *W1dG#Np}
1D7`YKI9h
</package> eHZws`W
70nqD>M4