这个SDK到底是什么东西啊,就提供了一个数据库连接工具么?直接用ADO连接SQL server有什么不同 Q^X}7Z|T
N@^:IfJ+=
下面的连接为什么连不上呢,连接字符串有什么问题吗?先谢过了 *JZlG%z
bGxHzzU}
<package> @gw8r[
Y8N
+v+V/
<Job id="getProjectCount"> ` }B,w-,io
<Script language ="JScript"> 1\g r
;b
hoLA*v2<
//create ADO connection object... yet~
7`&6l+S|
var cn = new ActiveXObject("ADODB.Connection");
\u;`Lf
R*r"};
//open connection... LjIkZ'HuF
:>F3es`
cn.Open("DSN=Primavera SDK;UID=pubuser;PWD=pubuser"); qd<I;*WV
8s
%Yu
dW
var NumRecAff;
;v/un
/U`p|M;
var adCmdUnknown = 8; //ado constant &xp]9$
U*,\UF
//execute SQL command… G,<l}(tEG
y>)c?9X
var rs = cn.execute("SELECT COUNT(*) FROM PROJWBS WHERE NODE_TYPE='PROJECT'",NumRecAff,adCmdUnknown); +r&
:c
[
q([{WZ:6Oq
WScript.echo("Project Count: " + rs.Fields.Item(0).Value); /_YTOSZjm
dGz4`1(>
%F^,6y
Q7i(M >|O
rs.Close(); 0Ue~dVrM(?
IW-|"5?9'
rs = null; m]H]0T
*adznd
R1eWPtWs
).A9>^6?{
cn.Close(); vVrM[0*c
B^/k`h6J
cn = null; 6As%<g=
3s67)n
R[)bGl
6#
),[@NK&=
</Script> )[|_q,
6 jm@`pYbE
</Job> L#J2J$=
`j!_tE`
</package> T7Y}v,+-
El: @l%