cannot occupy db session : select * from SK_SilkChange_BY_Web
cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64
DBConnect
PHP Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=MOTAZ-HP\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=pw123;"
DBConnA.Open strConnectA
%>
srGlobalService
PHP Code:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=pw123;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
srNodeType
PHP Code:
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.0.14
nip=192.168.0.14
machine_manager_node_id=699
srShard
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SROinfo
query=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pw123;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=MOTAZ-HP\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa;PWD=pw123;DATABASE=SRO_VT_LOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0