<%
'定義數據庫連接對象   
dim conn   
'定義數據庫連接字符串
dim connstr

   on error resume next
   'connstr = "DSN=job;UID=sa;PWD=sa7899;"
   connstr ="PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=sa;PWD=password;DATABASE=job" 
   set conn=server.createobject("ADODB.CONNECTION")
   if err then 
      err.clear
   else
        conn.open connstr 
        if err then 
           err.clear
        end if
   end if
%>