Web服务无法在服务器上找到存储过程 [英] Web service not able to find stored procedure on server

问题描述

我的Web服务连接到数据库.它可以在我的本地计算机上完美运行，但是当它上传到服务器时却无法正常工作.下面是错误消息:

System.Web.Services.Protocols.SoapException:System.Web.Services.Protocols.SoapException:服务器无法处理请求. ---> System.InvalidOperationException:存储过程"DropDownList_PackagesByMagID"不存在.

仅对于新创建的存储过程会发生这种情况，而对于旧的存储过程则可以在同一数据库上正常工作

有人可以告诉我如何解决吗?

谢谢，
Achuki

Hi,

My Webservices connects to database. It works perfectly on my local computer, but when uploaded to the server it doesn''t work. Below is the error message:

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: The stored procedure ''DropDownList_PackagesByMagID'' doesn''t exist.

This happens only for Newly created stored procedures but for Old stored procedures works fine on the same database

Can somebody please tell me how I can fix it?

Thanks,
Achuki

推荐答案

你好:

我认为您应该再考虑SQL Server安全性问题再检查一次SQL对象列表.例如，您正在使用的架构，user_id具有适当的权限等.

谢谢
Marufuzzaman博士

Hello:

I think you should review your SQL objects list one more time with considering SQL Server security issues. For example, schema, user_id you are using has the proper permission etc.

Thanks
Md. Marufuzzaman

我能够为同一数据库的现有存储过程运行webservices，但不适用于新的
我创建的存储过程.

直到星期五，新的存储过程仍能正常工作.但是今天，当我尝试运行我的应用程序时，它抛出了错误.没有代码更改.

我的应用程序连接到Web服务，该Web服务连接到数据库以获取数据.

考虑到安全性问题，那么它不应该允许任何存储过程执行，

Achuki

Hi,

I''m able to run webservices for already existing stored procedures for the same database, Its not working for new
stored procedures which i created.

Also till Friday new stored procedures was working fine. But today when I tried to run my application it threw above error. There was no code change.

My application connects to web-service which connects to database to get data.

Considering security issue then it should not have allowed any stored procedures to execute,

Achuki

这篇关于Web服务无法在服务器上找到存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！