Question

dw+asp语言（数据库连接）

数据库连接不成功，提示错误在第几行并提示，不支持控件Createobject
我用的是：
set adocon=Server.Createobject("adodb.connection")
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _ Server.MapPath("数据库所在路径")
出现：microsoft vbscript runtime error '800a01ad'
activex component can't create object :'server.creatobject'
\untitled-1.asp,line

Answer 1

数据库有密码时
set conn=server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;User Id=admin;jet OleDB:Database Password=dbh321;Data Source="&Server.MapPath("数据库所在路径")

数据库没密码时
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("数据库所在路径")

Answer 2

Db ="database/111.mdb"
ConnStr = "ProvIDer = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnStr

用这个

追问

IE出现：microsoft vbscript runtime error '800a01ad'
activex component can't create object :'server.creatobject'
\untitled-1.asp,line

Answer 3

<%

Dim MM_news_STRING
MM_news_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("\地址\名称.mdb")
%>

Answer 4

set adocon=Server.Createobject("adodb.connection")
adoconn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ="& Server.MapPath("数据库所在路径")
你的空格不要忘记

Answer 5

楼上几位全都正解。看你怎么给分。哈哈。

追问

代码是对的，浏览器显示错误