上边建立数据连接的变量名叫objConn,而下边你用conn.execute,对吗?再有,没有调用OpenConnection打开数据连接呀!试试我改的:
<%
dbConnect = "DRIVER={sql server};UID=sa;PWD=123;server=(local);database=web"
Sub OpenConnection()
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open dbConnect
End Sub
dim name,sex,tel,fax,email,intro
name=request.form("name")
sex=request.form("sex")
tel=request.form("tel")
fax=request.form("fax")
email=request.form("email")
intro=request.form("intro")
sql="insert into user(name,sex,tel,fax,email,intro)
楼上的写的太深了,看不懂。
请高手诊断:以下的代码,插入不上数据库。
<%
dbConnect = "DRIVER={sql server};UID=sa;PWD=123;server=(local);database=web"
Sub OpenConnection()
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open dbConnect
End Sub
dim name,sex,tel,fax,email,intro
name=request.form("name")
sex=request.form("sex")
tel=request.form("tel")
fax=request.form("fax")
email=request.form("email")
intro=request.form("intro")
sql="insert into user(name,sex,tel,fax,email,intro)