asp连接sqlserver
<%
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'
连接字符串属性无效
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'
连接字符串属性无效
...全文
相关推荐
asp连接mssql2005的代码
在ASP中连接数据库,特别是Microsoft SQL Server 2005(MSSQL2005),需要使用特定的连接字符串。
asp连接sqlserver数据库的几种方法
### ASP 连接 SQL Server 数据库的几种方法在 Web 开发领域,ASP(Active Server Pages)作为一种服务器端脚本环境,在与数据库交互方面有着广泛的应用。
asp.net测试SQLSERVER连接程序
```csharp connection.Close(); ```在描述中提到的"asp.net测试SQLSERVER连接程序"可能是一个简单的Web应用,它包含了一个网页,用户输入连接字符串,然后应用程序尝试连接到指定的
ASP 连接 SQL SERVER 2008的方法
此外,连接字符串中的SQL Server驱动程序名称(在连接字符串中用`driver={SQLServer}`表示)和Provider(如`sqloledb`)应与安装的SQL Server版本以及系统的
asp连接sqlserver2000
在ASP中,我们通常会用到`Connection`、`Command`和`Recordset`等对象。2. **连接字符串**:建立ASP与SQL Server的连接首先需要一个有效的连接字符串。


