我现在要做一个网站,是用ASP和SQL做的,可是我现在只有ASP和ACCESS的源程序,我想问一下,ACCESS怎样转换面SQL的,除了在连接语句上改一下,其他涉及数据库的语句哪些要改呢,急呢

现在看一下登陆注册的源程序,里面有ACCESS的数据,想请高手们,把他导入SQL然后再运行,我试过了,可是运行不起来哦,就登陆那一块,帮忙吧
弄好给我留言好不?zzhjulie@126.com 重谢哦

程式在哪里?

Access在SQL Server2000里能自动导入后就直接转换为SQL数据库了。

那其他的语句就不用改了么，可是怎么还是运行不起来呢

<!--#include file="conn.asp"-->
<!--#include file="md5.asp"-->
<%dim username,userpassword,comeurl
username=replace(trim(request("username")),"'","")
userpassword=md5(replace(trim(request("userpassword")),"'",""))
if username="" or userpassword="" then
response.write "<script LANGUAGE='javascript'>alert('对不起！您的用户名或密码有误！');history.go(-1);</script>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [user] where username='"&username&"' and userpassword='"&userpassword&"' " ,conn,1,3
if not(rs.bof and rs.eof) then
if userpassword=rs("userpassword") then
response.Cookies("songxf")("username")=trim(request("username"))
response.Cookies("songxf")("reglx")=rs("reglx")
response.Cookies("songxf")("jiaoyijine")=rs("jiaoyijine")

Response.Cookies("aspsky")("username") = rs("username")
Response.Cookies("aspsky")("password") = rs("userpassword")
Response.Cookies("aspsky")("userclass") = rs("userclass")
Response.Cookies("aspsky")("userid") =rs("userid")
Response.Cookies("aspsky")("userhidden") = 2
Response.Cookies("aspsky").path="/shop/shop/bbs/"
Response.Cookies("aspsky")("usercookies") = 1
Response.Cookies("aspsky").Expires=Date+1

rs("lastlogin")=now()
rs("logins")=rs("logins")+1
rs("userlastip")=Request.ServerVariables("REMOTE_ADDR")
rs.Update
rs.Close
set rs=nothing
username=trim(request("username"))
conn.execute("delete from shop_action where username='"&username&"' and zhuangtai=7")
conn.execute("delete from shop_action_jp where username='"&username&"' and zhuangtai=7")
if request("linkaddress")="" then
response.redirect request.servervariables("http_referer")
else
response.redirect request("linkaddress")
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起，您的用户名或密码有误！');history.go(-1);</script>"
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起！您的用户名或密码有误！');history.go(-1);</script>"
end if
'sub loginok()
'response.Write "<font size=2>欢迎您 <font color=red size=2>"&request.Cookies("bookshop")("username")&"</font>，两秒种后将自动跳转到相应页！</font>"
'response.redirect "index.asp"
'end sub
%>
上面是检验用户名和密码的，可是，我输入用户名和密码以后老出现“对不起！你的用户名或密码有错误！”
再帮我看一下conn.asp
<%
dim conn,connstr
set conn=server.createobject("adodb.connection")
connstr="Driver={SQL Server};server=J92;uid=sa;pwd=;database=shibang"
conn.Open connstr
%> 上面的程序有错么

<!--#include file="conn.asp"-->
<!--#include file="md5.asp"-->
<%dim username,userpassword,comeurl
username=replace(trim(request("username")),"'","")
userpassword=md5(replace(trim(request("userpassword")),"'",""))
if username="" or userpassword="" then
response.write "<script LANGUAGE='javascript'>alert('对不起！您的用户名或密码有误！');history.go(-1);</script>"
response.end
end if
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [user] where username='"&username&"' and userpassword='"&userpassword&"' " ,conn,1,3
if not(rs.bof and rs.eof) then
if userpassword=rs("userpassword") then
response.Cookies("songxf")("username")=trim(request("username"))
response.Cookies("songxf")("reglx")=rs("reglx")
response.Cookies("songxf")("jiaoyijine")=rs("jiaoyijine")

Response.Cookies("aspsky")("username") = rs("username")
Response.Cookies("aspsky")("password") = rs("userpassword")
Response.Cookies("aspsky")("userclass") = rs("userclass")
Response.Cookies("aspsky")("userid") =rs("userid")
Response.Cookies("aspsky")("userhidden") = 2
Response.Cookies("aspsky").path="/shop/shop/bbs/"
Response.Cookies("aspsky")("usercookies") = 1
Response.Cookies("aspsky").Expires=Date+1

rs("lastlogin")=now()
rs("logins")=rs("logins")+1
rs("userlastip")=Request.ServerVariables("REMOTE_ADDR")
rs.Update
rs.Close
set rs=nothing
username=trim(request("username"))
conn.execute("delete from shop_action where username='"&username&"' and zhuangtai=7")
conn.execute("delete from shop_action_jp where username='"&username&"' and zhuangtai=7")
if request("linkaddress")="" then
response.redirect request.servervariables("http_referer")
else
response.redirect request("linkaddress")
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起，您的用户名或密码有误！');history.go(-1);</script>"
end if
else
response.write "<script LANGUAGE='javascript'>alert('对不起！您的用户名或密码有误！');history.go(-1);</script>"
end if
'sub loginok()
'response.Write "<font size=2>欢迎您 <font color=red size=2>"&request.Cookies("bookshop")("username")&"</font>，两秒种后将自动跳转到相应页！</font>"
'response.redirect "index.asp"
'end sub
%>
上面是检验用户名和密码的，可是，我输入用户名和密码以后老出现“对不起！你的用户名或密码有错误！”
再帮我看一下conn.asp
<%
dim conn,connstr
set conn=server.createobject("adodb.connection")
connstr="Driver={SQL Server};server=J92;uid=sa;pwd=;database=shibang"
conn.Open connstr
%> 上面的程序有错么

把你的数据库里字段名改一下试试看,
比如在后面加一1:username1
很多字段名在ACCESS里可用,用到SQL就不行了!
我没怎么学过SQL,自已随便用的,所以不知哪些字段名是不可用的!

用的是动网?