<% 'Database Connection 'DBConn : 설문 DataBase 'RSConn : List Database Dim DBFlag,RBFlag '########################################################################################### 'CAPI 시스템 DB 연결 '########################################################################################### Sub DBConnect() Set DBConn=Server.CreateObject("ADODB.Connection") DBConn.CursorLocation = adUseClient DBConn.CommandTimeout = 0 ' select 쿼리 시간 무제한 DBConn.Open GetDBStr() DBFlag = True End Sub '########################################################################################### 'CAPI Project DB 연결 '########################################################################################### Sub DBConnect1() Set DBConn=Server.CreateObject("ADODB.Connection") DBConn.CursorLocation = adUseClient DBConn.Open GetDBStr1() DBFlag = True End Sub Sub DBConnect2() Set DBConn=Server.CreateObject("ADODB.Connection") DBConn.Open GetDBStr2() DBConn.CursorLocation = adUseClient DBFlag = True End Sub Function GetDBStr() GetDBStr = "Driver=SQL Server; Server=" & SV_NAME & "; Database=" & DB_NAME & "; UID=" & UID & "; PWD=" & PWD End Function Function GetDBStr1() GetDBStr1 = "Driver=SQL Server; Server=" & SV_NAME1 & "; Database=" & DB_NAME1 & "; UID=" & UID1 & "; PWD=" & PWD1 '20220711 박준성 인트라넷 -> kon 'GetDBStr1 = "Provider=SQLOLEDB; Server=1.235.195.8,20022;Initial Catalog=kon; UID=kon; PWD=kon#51304" End Function Function GetDBStr2() GetDBStr2 = "Provider=SQLOLEDB; Server=" & SV_NAME2 & ";Initial Catalog=" & DB_NAME2 & "; UID=" & UID2 & "; PWD=" & PWD2 End Function 'DB 끊기 Sub DBClose() If Not DBConn Is Nothing Then DBConn.Close Set DBConn = Nothing End If DBFlag = False End Sub %>