Set conn = Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL Server};server=CUI;uid=sa;pwd=;database=bbs"
conn.Open connstr
conn.Execute "insert into member(name,password,sex,marked) values('"&name1&"','"&pass1&"','"&sex1&"','"&mark1&"')",1,3
conn.Close
set conn=nothing
这些代码有问题吗?
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL Server};server=CUI;uid=sa;pwd=;database=bbs"
conn.Open connstr
结果错误是:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
/
ASP与SQL数据库连接:
<%
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称
%>
oledb直接连接
set cnobj = Server.CreateObject("ADODB.Connection")
strcon="PROVIDER=SQLOLEDB;DATA SOURCE=(主机名称或ip,如果是本地,可以不要);DATABASE=(数据库名,注不是保存的文件名,而是企业管理器中的数据库名称);UID=(登陆名);PWD=(登陆密码)"
cnobj.Open strcon
set rstobj=server.createobject("adodb.recordset")
set rstobj=cnobj.execute("select * from users")
如:
set cnobj = Server.CreateObject("ADODB.Connection")
strcon="PROVIDER=SQLOLEDB;DATA SOURCE=CUI;DATABASE=bbs;UID=sa;PWD=(登陆密码)"
cnobj.Open strcon
set rstobj=server.createobject("adodb.recordset")
set rstobj=cnobj.execute("select * from member")