Professional Web Applications Themes

Stored Procedure not found - ASP Database

I have a strange problem (to me at least). I am using SQL Server 2000 with ASP and ADO. I created a stored procedure as a user and granted permissions to it to my 'webuser' user that I use to connect to the db. I can execute this sp just fine if I connect with my own login but when I try to user the webuser user I get the 'Could not find stored procedure 'blahblah'. Has anyone else encountered this ? Any ideas would be greated appreciated. SusanC *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get ...

  1. #1

    Default Stored Procedure not found

    I have a strange problem (to me at least). I am using SQL Server 2000
    with ASP and ADO. I created a stored procedure as a user and granted
    permissions to it to my 'webuser' user that I use to connect to the db.
    I can execute this sp just fine if I connect with my own login but when
    I try to user the webuser user I get the 'Could not find stored
    procedure 'blahblah'. Has anyone else encountered this ? Any ideas
    would be greated appreciated.



    SusanC

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Susan Guest

  2. #2

    Default Re: Stored Procedure not found

    From my limited knowledge on SQL server object ownership, the object
    "belongs" to whomever that created it. So, if you created the sp, the way to
    refer to it is:

    <owner_name>.<stored_proc_name>

    in most cases, this is dbo.<stored proc name>. You might want to use that
    notation to refer to the SP. To check who the object belongs to, go to the
    enterprise manager, and the check for the name next to the stored proc name
    in the list of stored procs.

    Hope that helps.

    --
    Manohar Kamath
    Editor, .netWire
    www.dotnetwire.com


    "Susan Cranford" <state.fl.us> wrote in message
    news:phx.gbl... 


    Manohar Guest

  3. #3

    Default Re: Stored Procedure not found

    Susan Cranford wrote: 

    You mean when you use Query yzer?
     

    Can you connect to the database under the webuser account from Query
    yzer? If so, is the procedure usable there? If so, then the problem is
    in your connection string.
    Let's see your connection string.

    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Guest

  4. #4

    Default Re: Stored Procedure not found

    Thanks. I don't understand it but I found a way around it. It seems
    like if you give another user the permission to use an sp it should be
    okay...but anyway what I did was delete the sp and re-create it with
    dbo.spname and that made it happy.

    Again thanks so much for your help, it is always greatly appreciated!

    SusanC

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Susan Guest

Similar Threads

  1. help with a stored procedure
    By Jason Tesser in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 3rd, 05:35 PM
  2. is it a bug in Stored Procedure?
    By Rickey in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 16th, 01:47 PM
  3. Stored Procedure Help
    By Jack in forum Microsoft SQL / MS SQL Server
    Replies: 7
    Last Post: July 14th, 06:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139