| smoothboy |
2009-08-29 11:30 |
Primavera SDK 的数据库连接
这个SDK到底是什么东西啊，就提供了一个数据库连接工具么？直接用ADO连接SQL server有什么不同 1"PE@!]
2a-hf|b1
下面的连接为什么连不上呢，连接字符串有什么问题吗？先谢过了
p$ v +L
w+P^c |
<package> >*CK@"o
5(Oc"0''H
<Job id="getProjectCount"> 11+_OC2-
<Script language ="JScript"> h]9^bX__Z
k JF HUR
//create ADO connection object... f
d5 ~'2
LXl ! !i%
var cn = new ActiveXObject("ADODB.Connection"); lNAHn<ht
P2F>iK#U
//open connection... rfpxE>_|G
Z Z7U^#RT
cn.Open("DSN=Primavera SDK;UID=pubuser;PWD=pubuser"); E~^' w.1
,iUx'U
var NumRecAff; 1YL5 ![T
J K^;-&
var adCmdUnknown = 8; //ado constant ?Q2pD!L{
Xi.?9J`@
//execute SQL command… ls Ch K
*E'K{?-K
var rs = cn.execute("SELECT COUNT(*) FROM PROJWBS WHERE NODE_TYPE='PROJECT'",NumRecAff,adCmdUnknown); Ea?.H Rxl
L4b4
X
WScript.echo("Project Count: " + rs.Fields.Item(0).Value); T:$_1I $
Q2Rj0E`
pkx>6(Y
g_U69
z
rs.Close(); CgC wM=!r
u7d]%<~'$F
rs = null; L8ke*O$
bSfQH4 F
>.|gmo>b
r;z A `
cn.Close(); L%FL{G
O;2 u1p'iP
cn = null; %L 3 ]l
$]FWpr%)
/
<p HDY
3nO|A: t
</Script> ~
4a aJ0
g5)VV"
</Job> RulI
zv
4%TC 2Laii
</package> n[@ Ur2& )
\"SI-` x
|
|