一、连接无密码数据库：
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("db.mdb")
二、连接带密码的数据库：
第一种：Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("db.mdb")&";pwd=123"
第二种：Set conn = Server.CreateObject("ADODB.Connection")
conn.open = "provider=microsoft.jet.oledb.4.0;Jet OLEDB:Database Password=1234;" & "data source = " & server.mappath("db.mdb")
三、ASP与Access数据库连接：
1、ODBC方式：
mdbfile=server.mappath("数据库名称.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};uid=admin;pwd=数据库密码;dbq="&mdbfile
2、OLEDB方式：
dim conn,mdbpath
mdbpath=Server.mapPath("数据库名称.mdb")
set conn=Server.CreateObject("adodb.connection")
conn.open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&mdbpath
四、ASP与SQL数据库连接：
dim conn
set conn=server.createobject("ADODB.connection")
con.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称
五、ASP与EXCEL数据库连接：
Set Conn = Server.CreateObject("ADODB.Connection")
Driver = "Driver={Microsoft Excel Driver (*.xls)};"
DBPath = "DBQ=" & Server.MapPath("book.xls")
Conn.Open Driver & DBPath
Sql="Select * From [Sheet1$]"
Set Rs=Conn.Execute(Sql) |
