http://www.weedjc.com/ zh-cn PBlog2 v2.4 http://www.weedjc.com/images/logos.gif http://www.weedjc.com/ 像杂草一样疯长 http://www.weedjc.com/article/Resources/63.htm weed-jc@163.com(毛毛) Fri,10 Aug 2007 14:16:59 +0800 http://www.weedjc.com/default.asp?id=63
<%
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=aduseclient dsntemp="provider=msdaora.1;password=xxxxx;userid=yanhang;datasource=xxx.world"
conn.open　dsntemp

%>  
]]>