ASP与数据库连接问题

ASP与数据库连接问题归纳如下:

一、与ACCESS连接

<%

dim connstr,datafile

datafile="ok.mdb"

''on error resume next''

connstr="DBQ="+server.mappath(datafile)+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=" & Server.MapPath(datafile)set conn=server.createobject("ADODB.CONNECTION")conn.open connstr

%>

二、与SQL Server连接

<%

dim conn,strcnn

set conn=server.createobject(''ADODB.Connection")

strcnn="Provider=sqloledb;User id=sa;password=123456;Initial Catalog=database;data source=(local)"

conn.open strcnn

%>