Jason Blog

access数据库连接用dsn连接并且没有用户名和密码：<%set　conn　=　server.createobject("adodb.connection")conn.open　"yourdsnname"%>用dsn连接并且有用户名和密码：<%set　conn　=　server.createobject("adodb.connection")conn.open　"yourdsnname","username","password"%>用实际的数据库绝对路径连接：<%set　conn　=　server.createobject("adodb.connection")strconn="driver=;　"strconn=strconn　&　"dbq=e:\yanhang\database.mdb"　conn.open　strconn%>用实际的数据库相对路径连接：<%set　conn　=　server.createobject("adodb.connection")strconn="driver=;　"strconn=strconn　&　"dbq="　&　server.mappath("/database/yanhang.mdb")conn.open　strconn%>ms　sql　server数据库连接用dsn连接：<%set　conn　=　server.createobject("adodb.connection")conn.open　"dsn=mydsn;uid=user;pwd=password;database=databasename"%>不用dsn连接：<%set　conn　=　server.createobject("adodb.connection")dsntemp="driver=;server=servername;uid=user;pwd=password;database=databasename"conn.open　dsntemp%>foxpro数据库连接<%set　conn　=　server.createobject("adodb.connection")connstr=　"driver=microsoft　visual　foxpro　driver;　uid=userid;sourcetype=dbc;sourcedb=c:\yanhang\database.dbc"conn.open　connstr%>oracle数据库连接：<%set　conn=server.createobject("adodb.connection")conn.cursorlocation=aduseclientdsntemp="provider=msdaora.1;password=xxxxx;user　id=yanhang;data　source=xxx.world"conn.open　dsntemp%>