1.
2.
3.
OleDbConnection
cn=new OleDbConnection(strConn);
cn.Open();
смотрю
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
select
p.spid,
p.fid,
p.status,
suser_name(p.suid) as login,
db_name(p.dbid) as db_name,
object_name(l.id,l.dbid) as table_name,
p.program_name,
object_name(p.id,p.dbid) as procedure_name,
p.cmd,
p.stmtnum,
p.linenum,
p.cpu,
p.physical_io,
p.memusage,
p.blocked,
l.class,
v.name as name_L,
vlc.name as name_L2,
p.time_blocked,
l.page,
l.row,
p.tran_name,
p.priority,
p.loggedindatetime,
p.hostname,
p.ipaddr
from
master..sysprocesses p
left outer join master..syslocks l on p.spid = l.spid
left outer join master..spt_values v on l.type = v.number and v.type = 'L'
left outer join master..spt_values vlc on l.context + 2049 = vlc.number and vlc.type = 'L2'
where
(p.spid!= 0 )
and (p.spid!=@@SPID)
Все в порядке:
ОДИН пользовательский коннект
1.
2.
OleDbCommand
cmd=cn.CreateCommand();
cmd.cmdConnection.State==System.Data.ConnectionState.Open
1.
2.
3.
cmd.CommandText="select @@spid";
if((tmpObject=cmd.ExecuteScalar())!=null)
spid=Convert.ToInt64(tmpObject);
пользовательских коннекта!!!
Зачем? Почему? Кто виноватЪ? Что делатЪ?
P.S. Connection Pool - вкл.
select @@version
Adaptive Server Enterprise/12.5.1/EBF 11428/P/NT (IX86)/OS 4.0/ase1251/1823/32-bit/OPT/Wed Sep 17 11:10:54 2003
ASE OLE DB Provider (sydaase.dll ver. 2.70.0.23)
_________________
"Helo, word!" - 17 errors 56 warnings
Posted via ActualForum NNTP Server 1.4
