Problem connecting to Oracle database using ASP
From: js <androidsun_at_yahoo.com>
Date: 8 Jun 2003 20:49:17 -0700
Message-ID: <23869fd0.0306081949.41c46501_at_posting.google.com>
Date: 8 Jun 2003 20:49:17 -0700
Message-ID: <23869fd0.0306081949.41c46501_at_posting.google.com>
<%option explicit%>
<%
Response.Expires = -1 'expires immediately
dim strCn, cn
dim strStatus
set cn = server.CreateObject("ADODB.connection")
with cn
.connectionString = strCn
.open
end with
Select Case cn.State
Case 1 'adStateOpen
strStatus = "open"
Case 0 'adStateClosed
strStatus = "Closed"
Case Else
strStatus = "Other Status (" & cn.state & ")"
End Select
response.write "Connection state: " & strStatus
%>
Received on Mon Jun 09 2003 - 05:49:17 CEST