asp连接sqlserver

[qq_20364589]

<%
if request("submit")="输入" then
//set conn=opendb("oabusy","conn","accessdsn")
dim sql
sql = "Insert Into

power(store_name,power_data,msg,server_status,net_status,ups_power,re_power_data,no_power,ups_end_sta,other)

Values( "
sql = sql & SqlStr(store_name) & ", "
sql = sql & SqlStr(power_data) & ", "
sql = sql & SqlStr(msg) & ", "
sql = sql & SqlStr(server_status) & ", "
sql = sql & SqlStr(net_status) & ", "
sql = sql & SqlStr(ups_power) & ", "
sql = sql & SqlStr(re_power_data) & ", "
sql = sql & SqlStr(no_power) & ", "
sql = sql & SqlStr(ups_end_sta) & ", "
sql = sql & SqlStr(other) & ") "
ConnStr="Provider=SQLOLEDB.1;DataSource=goat;User ID=sa;Persist Security Info=False;Password=123456;Initial

Catalog=app"
set conn=Server.Createobject("adodb.connection")
conn.open Connstr
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.addnew
//conn.Execute sql
%> 各位高手看看，报错Microsoft OLE DB Provider for SQL Server 错误 '80004005'

连接字符串属性无效

[J_Vernon]

set Conn=Server.Createobject("Adodb.Connection")
Conn.open "Driver={sql server};Server=(local);Database=数据库名称;uid=sa;pwd=数据库密码"

[toorup]

这里看不到你连接数据库的语句，只看到插入语句，而提示是连接问题。
你要把你的连接语句一起发出来。

[hookee]

连接串要和数据库版本匹配

[vstudiocn]

你的问题有以下方便 1.连接串有问题ConnStr="DRIVER={SQL Server};Server={IP地址};uid=用户名;pwd=密码;database=数据库名称" 2.sql语句里是insert into,则不能rs.open sql,conn,1,3和rs.addnew,只能使用conn.Execute sql

[Gx_^]

从网上找个DBHelper类加到你的项目中 在dbhelper中连接数据库 增删改直接调用dbhelper中的方法