初学asp，写了一段连接SQL Server数据库的代码，出错了，请各位高手指教

1   
2dim conn   
3Setconn=Server.CreateObject("ADODB.Connection")   
4conn.Open"driver={SQLServer};server=192.168.0.201; uid=sa;pwd="";database=wjg"   
5conn open   
6  

1   
2sql="select * from author_en"   
3set rs=conn.execute(sql)   
4while not rs.eof   

1=rs("firstname")

1rs.movenext   
2wend   
3rs.close   
4set rs=nothing   
5conn.close   
6set conn=nothing   

不太懂asp，请指教！
---------------------------------------------------------------

con.open "Driver={SQL Server}; Database=数据库; Server=(Local); uid=sa; pwd="
---------------------------------------------------------------

wend--------????
rs.close
set rs=nothing
conn.close
set conn=nothing

---------------------------------------------------------------

不是
Setconn=Server.CreateObject("ADODB.Connection")
应该为：
Set conn=Server.CreateObject("ADODB.Connection")
---------------------------------------------------------------

这是我的连接代码

1   
2dim conn   
3dim connstr   
4on error resume next   
5connstr="Driver={SQL Server};Database=wjjbj;Server=GJ;Uid=pjp;Pwd="   
6set conn=server.createobject("ADODB.CONNECTION")   
7conn.open connstr   

---------------------------------------------------------------

如果是你的sql在本机上,用server=(local),你那``` =rs("firstname")

1动作命令,如response.write等