asp 连接 2008 数据库，那里错了！忘各位大侠指点！

<%
Dim StrServer,StrUid,StrSaPwd,StrDbName,conn,StrDSN
StrServer="(local)"
StrUid="sa"
StrSaPwd="qwe`123"
StrDbName="bbs"
StrDSN="driver={sql server};server=" & StrServer &";uid=" & StrUid & ";pwd=" & StrSaPwd & ";database="& StrDbName & ";"
set conn=Server.CreateObject("ADODB.Connection")
conn.Open StrDSN
 if conn.state=2 Then
 Response.Write("正在连接")
 else if conn.state=1 then
 Response.Write("连接已经打开")
 else
 Response.Write("对不起，无法打开连接")
 End if
%>