asp 資料庫連接程式

<%@ LANGUAGE = VBScript CodePage = 936%>
<!--#include file="safe.asp" -->
<%

On Error Resume Next
Response.Buffer = True
dim startime
dim conn
dim connstr
dim sqldatabase,sql_pass_word,sql_User_ID,sql_Data_Source
startime=timer()
Set conn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=SQLOLEDB.1;Password='88888547&*($';Persist Security Info=False;User ID='888';Initial Catalog='888';Data Source='888'"
conn.Open connstr
'ConnStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local)"
'conn.Open connstr
'conn.DefaultDatabase = "dgjob"
Sub CreateRS(sql,lv1,lv2)
   set rs=server.CreateObject("adodb.recordset")
   rs.open sql,conn,lv1,lv2
End sub

function CloseDb
 Conn.close
 Set conn = Nothing
End Function

If Err Then
 Response.Write "<!--" & Err.Number & ":" & Err.Description & "-->" & vbcrlf
 Response.Write "<!--" & conn.ConnectionString & "-->" & vbcrlf
 Response.Write "資料庫連接出錯，請檢查串連字串。"'注釋，需要把這幾個字翻譯成英文。
 err.Clear
 Set Conn = Nothing
 Response.End
End If

 function rsclose
 set rs=nothing
 end function

 function connclose
 conn.close
 set conn=nothing
 end function

%>