su.dbms
- SU.DBMS ----------------------------------------------------------------------
From : Ђ«ҐЄбҐ© Њ ¬®®ў 2:5080/1003.2 16 Feb 2002 11:05:11
To : Sergey Popkov
Subject : Re: SQL Server2000 и ADO
--------------------------------------------------------------------------------
You wrote to Алексей Мамонов on Fri, 15 Feb 02 07:45:20 +0500:
АМ>> Hу и поставь timeout поболее. См. CommandTimeout Property у
АМ>> ADODB.Connection или ADODB.Command.
SP> в том-то все и дело - не помогает..
А как делал?
create procedure killme1 as
waitfor delay '00:01:00'
Dim cnn As New ADODB.Connection
cnn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;" _
& "Trusted_Connection=Yes;Initial Catalog=testdb;Data Source=myserv"
cnn.Open
Dim cmd As New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "killme1"
cmd.Execute
Так - не работает.
Dim cnn As New ADODB.Connection
cnn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;" _
& "Trusted_Connection=Yes;Initial Catalog=testdb;Data Source=myserv"
cnn.Open
Dim cmd As New ADODB.Command
Set cmd.ActiveConnection = cnn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "killme1"
cmd.CommandTimeout = 120 ' !!!
cmd.Execute
А вот так - работает.
BR, Alex.
--- ifmail v.2.14dev3
* Origin: Controling/UTC (2:5080/1003.2@fidonet)
Вернуться к списку тем, сортированных по: возрастание даты уменьшение даты тема автор
|
