🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #9492

Re: ��λ��access�е���ݱ����

#9492
From: ���֮��
Date: Tue, 29 Jul 2003 12:30
17 lines
1556 bytes
������һ����ASP��ȡaccess����Ĵ��룬��֪�����Ƿ�����
<%
        strConn="DBQ="+server.mappath("data/xxx.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
        set objConn=server.createobject("Adodb.connection")
        objConn.open strConn
        set rsSchema=objConn.openSchema(20)
        rsSchema.movefirst
        Do Until rsSchema.EOF
                if rsSchema("TABLE_TYPE")="TABLE" then
                        response.write rsSchema("TABLE_NAME") & "<br>"    
                end if
                rsSchema.movenext
        Loop
        set objConn=nothing
%> 
--
�� ��Դ:����ɽ��Ժ BBS http://bbs.qxntc.edu.cn [FROM: 61.234.55.3]
Technical Details
Message-ID: <47S4QG$ZKB@bbs.qxntc.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.uestc.edu.cn!QXNTC

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,c0b9e62322ffc3b2
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-07-29 05:32:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.uestc.edu.cn!QXNTC
From: Windancer.bbs@bbs.qxntc.edu.cn (���֮��)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��λ��access�е���ݱ����
Date: 29 Jul 2003 12:30:40 GMT
Organization: ��ɽ��Ժ_BBS
Message-ID: <47S4QG$ZKB@bbs.qxntc.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: Database/M.1059481840.A
Lines: 17