数据库连接文件
来源:百度知道 编辑:UC知道 时间:2024/05/31 20:52:07
<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & Server.MapPath("*.asp")
objConn.Open
strSQL = "SELECT id,flashurl FROM flash"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 1, 1
Count=objRS.RecordCount
Item=1
redim a(Item, 2),t(Count)
for each j in t
j=0
next
Randomize timer
for j=1 to Item
k=int(rnd*Count+1)
do while t(k)<>0
k=int(rnd*Item+1)
loop
t(k)=1
next
j=1:i=1
Do While Not objRS.Eof
if t(j)=1 then
a(i,1)=objRS("id&quo
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & Server.MapPath("*.asp")
objConn.Open
strSQL = "SELECT id,flashurl FROM flash"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 1, 1
Count=objRS.RecordCount
Item=1
redim a(Item, 2),t(Count)
for each j in t
j=0
next
Randomize timer
for j=1 to Item
k=int(rnd*Count+1)
do while t(k)<>0
k=int(rnd*Item+1)
loop
t(k)=1
next
j=1:i=1
Do While Not objRS.Eof
if t(j)=1 then
a(i,1)=objRS("id&quo
同样的都是ACCESS数据库, 不需要任何改动哈
-----------------------------------------
偶本地测试没问题哈..:)
看一下是什么错误, 贴上来再说哦..
不过个人不太喜欢Microsoft Access Driver这种方式, 经常动不动就罢工...特别是不小心多刷新几次之后..