change localhost to your sql server machine name:
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>see more connection strings at
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#DSN
<%
sConn = "Provider=SQLOLEDB;Database=法律sql;Server=localhost;UID=sa;PWD=19791010;"
set conn = Server.CreateObject("ADODB.Nonnection")
conn.Open sConn
set rs = conn.Execute("select * from [l1000]")
do until rs.EOF
for i=0 to rs.fields.count - 1
Response.Write rs.fields(i).name & "=" & rs.fields(i).value & "<BR>"
next
rs.moveNext
loop
rs.close
conn.close
set conn=nothing
%>see more connection strings at
http://www.able-consulting.com/ado_conn.htm?f=ado_conn.htm#DSN
解决方案 »
- sql循环替换
- sql server2000怎样在查询分析器中用语句把老库的数据导入到新库中
- 一个update 的写法求解
- 关于在Windows2003下做SQL Server2000数据库集群遇到的几个问题------------有知道的大虾进来顶一下,急!!!!
- 寻SQL2005 AGENT相关资料
- 触发器可以这样写吗 向一个表添加一条信息 另外一个表同时也添加刚刚添加的那条信息
- 如何解决sql server 内存增长问题
- 存儲過程問題??
- 求救!在SQL SERVER 2000里用企业管理器打不开表!!
- 建一个表的问题。
- 我用osql登录,出现情况,请帮忙啊啊!
- 请帮一下菜鸟关于SQL学习的问题
conn.Open "Provider=SQLOLEDB;Data Source=服务器;Initial Catalog=表;User ID=用户;Password=密码;"这个应该是效率最高的连接方式了!