69 lines
1.8 KiB
Plaintext
69 lines
1.8 KiB
Plaintext
<%
|
|
|
|
'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
|
|
|
|
%>
|