UC知道ASP中的数据库连接问题
来源：百度知道 编辑：UC知道 时间：2024/05/25 14:09:04
出现这种错误
Microsoft JScript 编译错误 (0x800A03EC)
缺少 ';'
/344.asp, line 9, column 4
set conn = Server.CreateObject("ADODB.Connection")
---^
源代码：
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("database/db1.mdb")
Set rstemp=Server.CreateObject("ADODB.RecordSet");
sqltemp="insert into neirong values('wo')";
connectme="02";
rstemp.Open sqltemp,connectme;
%>
Microsoft JScript 编译错误 (0x800A03EC)
缺少 ';'
/344.asp, line 9, column 4
set conn = Server.CreateObject("ADODB.Connection")
---^
源代码：
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("database/db1.mdb")
Set rstemp=Server.CreateObject("ADODB.RecordSet");
sqltemp="insert into neirong values('wo')";
connectme="02";
rstemp.Open sqltemp,connectme;
%>
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("database/db1.mdb")
改为
db = "database/db1.mdb"
connstr= "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connstr
把
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
改为
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
或者, 干脆把它去掉
同时, 把所有句尾的分号去掉
大哥, 你的语法是VB的, 怎么又带个分号? 页面语言又是JAVASCRIPT, 好混乱呀.