site-dataconn.asp

简介：一个程序小巧而功能强大

<%
dim adoConn
set adoConn = Server.CreateObject("ADODB.Connection")
'选择你所要用的数据库:
'********* MSSQL 2000
'adoConn.ConnectionString = "DRIVER=SQL Server; SERVER=xxx.xxx.xxx.xxx; UID=xxx; PWD=xxx; DATABASE=xxx"
'********* MS Access 2000
'adoConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\username\bbs\db\bad.mdb' ;Jet OLEDB:Database Password=passw0rd"
'********* MS Access 2000 (Virtual Path)
'adoConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db//bad.mdb") &";Jet OLEDB:Database Password=passw0rd"
'********* MS Access (国外空间)
'adoConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/bbs/db/bad.mdb") &";Jet OLEDB:Database Password=passw0rd"
'********* MS Access (国外空间)
'adoConn.ConnectionString = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="& Server.MapPath("/USERNAME/bbs/db/bad.mdb") &";Jet OLEDB:Database Password=passw0rd"
adoConn.open
ConnConfigured = true
CMDText = &H0001
%>