'asp'에 해당되는 글 2건

  1. 2007/04/11 ASP의 DB Connection Timeout
  2. 2006/10/26 use oracle parametered query in asp
Dev & Mng2007/04/11 16:15

ASP의 DB Connection Timeout

Connection에 대한 Timeout 설정
    With oDbCon
        .CommandTimeout = 600
        .ConnectionTimeout = 600
        .Open strConnect
    End With

Command 객체에 대한 Timeout설정
    With oCmd
       .ActiveConnection = oDbCon
       .CommandType = &H0001
       .CommandText = qry
       .CommandTimeout = 600
       .Execute
   End With
Creative Commons License
Creative Commons License

'Dev & Mng' 카테고리의 다른 글

Gleam™님의 미투데이 - 2007년 4월 17일  (0) 2007/04/18
ASP의 DB Connection Timeout  (0) 2007/04/11
PowerShell Links  (0) 2007/03/31
Hotfix 설치 하지 않고 압축만 풀기  (0) 2007/03/27
Posted by Gleam™
TAG asp, Connection Timeout
Trackback 0 Comment 0
Dev & Mng2006/10/26 15:15

use oracle parametered query in asp

<%
   Dim objRs, strSql, j

   strSql = "SELECT * FROM buscompany WHERE sigunname = ?"

   With oCmd
       .ActiveConnection = dbcon
       .CommandType = adCmdText
       .CommandText = strSql
       .Parameters.Append .CreateParameter("sigunname", 200, &H0001, 20, "서울특별시")
       Set objRs = .Execute
   End With

   Do Until objRs.EOF
       Write(objRs("name"))
       objRs.MoveNext
   Loop

   Set objRs = Nothing
   Response.End
%>
Creative Commons License
Creative Commons License

'Dev & Mng' 카테고리의 다른 글

PowerBand 2.1.0.1  (0) 2006/11/09
use oracle parametered query in asp  (0) 2006/10/26
ADODB Command  (0) 2006/10/25
ADODB Type Library  (0) 2006/10/25
Posted by Gleam™
TAG asp, oracle, parametered query, query
Trackback 0 Comment 0