| View previous topic :: View next topic |
| Author |
Message |
trenton
Joined: 17 Nov 2004
Posts: 2
|
 Posted: Wed Nov 17, 2004 10:03 am Post subject: error '80040e14' Could not find stored procedure... |
 |
|
Hi,
I'm getting the following SQL Server error in one of my APS pages:
| Code: |
Microsoft OLE DB Provider for SQL Server error '80040e14'
Could not find stored procedure 'dbo.spGetUsers'.
|
The stored procedure spGetUsers does exist and I just don't knwo what to do. Help please!
Trenton |
|
| Back to top |
|
 |
administrator
Site Admin
Joined: 01 Oct 2004
Posts: 183
|
| Posted: Wed Nov 17, 2004 4:27 pm Post subject: |
|
|
Hi Trenton,
The error you got might be result of 2 things:
1. Your stored procedure doesn't exist (this is not the case)
2. The stored procedure is owned by a different owner than you have specified in your EXEC SQL call.
Check which SQL User owns your stored procedure, because this is most likely where the problem is.
Cheers,
_________________
Peter
ASP & ASP.NET Articles and Tutorials |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
