数据库连接

数据库连接 Connection , Connection , Set conn= Server.CreateObject(ADODB.Connection) Connection , , , Conn.open “,,” , , Conn.ConnectionString =“,,” , Conn.open Connection , , Conn.close , Set conn=nothing Connection , Set conn= Server.CreateObject(“ADODB.Connection”) , Conn.open “” , ADOSQL , Conn.close , Set conn=nothing Connection A ODBC DSN S P A DSN_lessD ODBC O OLE DB DSN , ODBCAccess , , “DSN=” , , 1“DSN” , 2Access2003 , Microsoft Access Driver(*.mdb) , 3Access2007 , Microsoft Access Driver(*.mdb, *.accdb) DSN_less , ADOAccess:Microsoft Access , Access2003 , “Driver={Microsoft Access Driver (*.mdb)}; DBQ=” , “Driver={Microsoft Access Driver (*.mdb)}; DBQ=“&Server.MapPath(“”) , Access2007 , “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=” , “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=“&Server.MapPath(“”) DSN_less , ADOAccess:Microsoft Access , Access2003 , “Driver={Microsoft Access Driver (*.mdb)}; DBQ=” , “Driver={Microsoft Access Driver (*.mdb)}; DBQ=“&Server.MapPath(“”) , Access2007 , “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=” , “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=“&Server.MapPath(“”)