首页 > 互联资讯 > 技术交流  > 

怎样获知数据库的连接属性?

<%@ Language=VBScript %>

<%

Option Explicit

dim objCNN

dim intCTProps

dim item

dim vbCRLF

vbCRLF = chr(10)

Response.Write " " & vbCRLF

Response.Write "

春风精彩之查看数据库属性

" & vbCRLF

Response.Write vbCRLF

set objCNN = Server.CreateObject("ADODB.connection")

objCNN.Open "DSN=VicTest"

Response.Write "

" & vbCRLF

Response.Write "

" & vbCRLF

intCTProps = 0

for each item in objCNN.Properties

intCTProps = intCTProps + 1

Response.Write "

" & vbCRLF

Response.Write "

" & vbCRLF

Response.Write "

" & vbCRLF

next

Response.Write "

>编号>Name>
" & intCTProps & "" & item.name & "" & item.value & "
" & vbCRLF

Response.Write vbCRLF

Response.Write " " & vbCRLF

set objCNN = Nothing

set intCTProps = nothing

set item = nothing

set vbCRLF = nothing

%>

怎样获知数据库的连接属性?由讯客互联技术交流栏目发布,感谢您对讯客互联的认可,以及对我们原创作品以及文章的青睐,非常欢迎各位朋友分享到个人网站或者朋友圈,但转载请说明文章出处“怎样获知数据库的连接属性?