1.

set dbconnection=Server.CREATEOBJECT("ADODB.CONNECTION")

DBPath = Server.MapPath("customer.mdb")

dbconnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath

SQL="select * from auth where id="" & user_id &"""

SET uplist=dbconnection.EXECUTE(SQL)

?

?

?

2.

set dbconnection=Server.CreateObject("ADODB.Connection")

DBPath = Server.MapPath("customer.mdb")

dbconnection.Open "provider=microsoft.jet.oledb.4.0;data source="&dbpath

SQL="select * from auth where id="" & user_id &"""

SET uplist=dbconnection.EXECUTE(SQL)

?

?

?

3.

DBPath = Server.MapPath("customer.mdb")

set session("rs")=Server.CreateObject("ADODB.Recordset")

" rs=Server.CreateObject("ADODB.Recordset")

connstr="provider=microsoft.jet.oledb.4.0;data source="&dbpath

SQL="select * from auth where id="" & user_id &"""

session("rs").Open sql,connstr,1,3

?

?

?

4.

建odbc源xxx

set conn=server.createobject("Adodb.connection")

conn.open "DSN=xxx;UID=;PWD=;Database=customer?