Click here to Skip to main content
12,242,747 members (63,188 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#2.0 C# SQL
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
Posted 3-Oct-11 4:23am
Edited 3-Oct-11 4:27am
RaisKazi34.3K
v3
Comments
Mehdi Gholam 3-Oct-11 9:44am
   
First make sure the sp exists on the server.
Bala Selvanayagam 3-Oct-11 9:49am
   
New sps could be in a different schema?
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

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
  Permalink  
Comments
Bala Selvanayagam 3-Oct-11 11:51am
   
Are you pointed to the right database ? perhaps your source is pointed to a test bed where the stored procedure is not there ?
Achuki Bhalotia 5-Oct-11 1:38am
   
Hi Bala,

All my stored procedures are in same database and only one connection string is used to connect.

Sp exists on the database and are in same schema as other sp's.

Also to highlisht everything was working fine but it stopped working for new stored proc without any change in code.

Please help.

Thanks
Achuki

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160426.1 | Last Updated 3 Oct 2011
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100