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?