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=aduseclient
dsntemp="provider=msdaora.1;password=xxxxx;user id=yanhang;data source=xxx.world"
conn.open dsntemp
%>
用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=aduseclient
dsntemp="provider=msdaora.1;password=xxxxx;user id=yanhang;data source=xxx.world"
conn.open dsntemp
%>