怎樣獲知數(shù)據(jù)庫的連接屬性
來源:易賢網(wǎng) 閱讀:2120 次 日期:2014-11-18 11:16:40
溫馨提示:易賢網(wǎng)小編為您整理了“怎樣獲知數(shù)據(jù)庫的連接屬性”,方便廣大網(wǎng)友查閱!

<%@ language=vbscript %>

<%

option explicit

dim objcnn

dim intctprops

dim item

dim vbcrlf

vbcrlf = chr(10)

response.write <html><head></head><body> & vbcrlf

response.write <p><h3>春風精彩之查看數(shù)據(jù)庫屬性</h3></p> & vbcrlf

response.write vbcrlf

set objcnn = server.createobject(adodb.connection)

objcnn.open dsn=victest

response.write <table border=1><tr><td width='10%'>>編號</td> & vbcrlf

response.write <td width='70%'>>name</td><td width='20%'>>值</td></tr> & vbcrlf

intctprops = 0

for each item in objcnn.properties

intctprops = intctprops + 1

response.write <tr><td> & intctprops & </td> & vbcrlf

response.write <td> & item.name & </td> & vbcrlf

response.write <td> & item.value & </td></tr> & vbcrlf

next

response.write </table> & vbcrlf

response.write vbcrlf

response.write </body></html> & vbcrlf

set objcnn = nothing

set intctprops = nothing

set item = nothing

set vbcrlf = nothing

%>

更多信息請查看IT技術專欄

更多信息請查看技術文章
易賢網(wǎng)手機網(wǎng)站地址:怎樣獲知數(shù)據(jù)庫的連接屬性
關于我們 | 聯(lián)系我們 | 人才招聘 | 網(wǎng)站聲明 | 網(wǎng)站幫助 | 非正式的簡要咨詢 | 簡要咨詢須知 | 新媒體/短視頻平臺 | 手機站點

版權所有:易賢網(wǎng)