动态网站（动态网站数据库连接的两种方式）

1 数据库连接:DSN和ADO2 DSN连接数据库2.1 打开或关闭windows功能：internet信息服务；2.2 在IIS服务器上建立新站点：InetMgr.exe→按上述内容创建（管理工具→Internet 信息服务(IIS)管理器:%windir%\system32\inetsrv\InetMgr.exe）→添加网站；2.3 DSN定义：管理工具→数据源(ODBC)：%windir%\system32\odbcad32.exe2.4 相关文件核心代码selfrecords.aspDim MM_selfrecords_STRINGMM_selfrecords_STRING = “dsn=wwu1;”admin.asp<!–#include file=”Connections/selfrecords.asp” –>Set Recordset1 = Server.CreateObject(“ADODB.Recordset”)Recordset1.ActiveConnection = MM_selfrecords_STRINGRecordset1.Source = “SELECT * FROM news ORDER BY vtime DESC”addform.asp<!–#include file=”Connections/selfrecords.asp” –>Set Recordset1 = Server.CreateObject(“ADODB.Recordset”)Recordset1.ActiveConnection = MM_selfrecords_STRINGRecordset1.Source = “SELECT * FROM news”<form ACTION=”add.asp” METHOD=”POST” id=”form1″ name=”form1″>add.aspset oConn = Server.CreateObject(“ADODB.Connection”)set oCmd = Server.CreateObject(“ADODB.command”)oConn.ConnectionString = “DSN=wwu1;”oConn.openSet oCmd.ActiveConnection = oConnmdofy.asp<!–#include file=”Connections/selfrecords.asp” –>MM_editConnection = MM_selfrecords_STRINGSet Recordset1 = Server.CreateObject(“ADODB.Recordset”)Recordset1.ActiveConnection = MM_wwu_STRINGRecordset1.Source = “SELECT * FROM news WHERE ID = ” +Replace(Recordset1__MMColParam, “‘”, “””) + “”del.asp<!–#include file=”Connections/selfrecords.asp” –>MM_editConnection = MM_selfrecords_STRINGSet Recordset1 = Server.CreateObject(“ADODB.Recordset”)Recordset1.ActiveConnection = MM_selfrecords_STRINGRecordset1.Source = “SELECT * FROM news WHERE ID = ” +Replace(Recordset1__MMColParam, “‘”, “””) + “”search.asp<form action=”result.asp” method=”post” name=”form1″ target=”_blank” id=”form1″>result.asp<!–#include file=”Connections/selfrecords.asp” –>Recordset1.ActiveConnection = MM_selfrecords_STRINGRecordset1.Source = “SELECT * FROM news WHERE ” + Replace(Recordset1__colkey1, “‘”, “””) + ” like ‘%” + trim(Replace(Recordset1__MMColParam, “‘”, “””)) + “%’ ORDER BY vtime DESC”3 ADO连接数据库相对于DSN连接来说,流程相对要简单一些,重点是下面的连接字符串:db= “\wwu.mdb”oConn.ConnectionString=”Provider=Microsoft.Jet.OLEDB.4.0;”&_”Data Source=” & Server.MapPath(db)-End_