2.对在sql server数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={sql server};database=数据库名称;server=(local);uid=sa;pwd="
3.对在oracle数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft odbc for oracle};uid=xxx;pwd=yyy;server=sss"
4.对在excel而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft excel driver (*.xls)};dbq=数据库名称"
5.对在dbase数据库而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver={microsoft dbase driver (*.dbf)};dbq=数据库名称"
6.对在text名称而言,数据库连接的asp程式码如下:
set conn = server.createobject("adodb.connection")
conn.open "driver= {microsoft text driver (*.txt; *.csv)};dbq=数据库名称"
<%
on error resume next
starttime=timer()
dim conn
dim dbpath
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("Data.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath & ";pwd=yemeng.net"
%>