公司网站做好了,要上传到网上,以前我用是access,现在空间是用sql的,下面这些代码该怎么改请对sal数据库驱动中那些参数给个说明
<%
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="& server.mappath("\bondrise\database\admin.mdb")%>
<%
set rs=server.createobject("ADODB.Recordset")
sql="select top 10 * from news order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
response.write"<a href='newcenter.asp?id=" & rs("id") & "' target='_blank'>" & rs ("content") & "</a><br/>------------------------------------------------<br/>"rs.movenext
loop
%>
<%
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source="& server.mappath("\bondrise\database\admin.mdb")%>
<%
set rs=server.createobject("ADODB.Recordset")
sql="select top 10 * from news order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
response.write"<a href='newcenter.asp?id=" & rs("id") & "' target='_blank'>" & rs ("content") & "</a><br/>------------------------------------------------<br/>"rs.movenext
loop
%>
'----------------------------------------------------------
strSQLServerName = "服务器名"
strSQLDBUserName = "数据库的登陆名"
strSQLDBPassword = "登陆用户的密码"
strSQLDBName = "数据库名"
'----------------------------------------------------------Set conn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
conn.Open connstr%><%
set rs=server.createobject("ADODB.Recordset")
sql="select top 10 * from news order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
response.write"<a href='newcenter.asp?id=" & rs("id") & "' target='_blank'>" & rs ("content") & "</a><br/>------------------------------------------------<br/>"rs.movenext
loop
%>
'----------------------------------------------------------
strSQLServerName = "218.244.136.24" ' 这个地方可以写服务器名或ip地址
strSQLDBUserName = "sa" ' 数据库的登陆名,如果给你的用户名是sa
strSQLDBPassword = "sa的密码"
strSQLDBName = "你的数据库名"
'----------------------------------------------------------'---------这个地方不用管,下面的是调用上面的变量连接数据库的-----
Set conn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
conn.Open connstr
'---------
%>