asp连接sqlserver

qq_20364589 qq_20364589 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
<%
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'

连接字符串属性无效
...全文

相关推荐

评论 5
收藏 已收藏
分享
返回顶部
qq_20364589
ASP 28,400 成员 356,938 内容