存贮过程未能找到?
做一BBS,用到存贮过程,出错:
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
未能找到存储过程 'wwfSpSelectConfiguration '。
从企业管理器上查看到,存贮过程wwfSpSelectConfiguration是存在的:
/****** Object: Stored Procedure cw59014.wwfSpSelectConfiguration Script Date: 2004-08-11 17:07:20 ******/
CREATE PROCEDURE [cw59014].[wwfSpSelectConfiguration] AS SELECT tblConfiguration.* From tblConfiguration;
GO
我修改了权限,还是不行。
出错的代码如下:
Set rsConfiguration = Server.CreateObject( "ADODB.Recordset ")
configuration details from the database
If strDatabaseType = "SQLServer " Then
strSQL = "EXECUTE wwfSpSelectConfiguration "
Else
strSQL = "SELECT tblConfiguration.* From tblConfiguration; "
End If
rsConfiguration.Open strSQL, strCon
------解决方案--------------------试一下用这个用户名登录 cw59014
------解决方案--------------------调用时,在存储过程前加上其所有者前缀,如:
dbo.wwfSpSelectConfiguration