Stored Procedure not found

[yeagly21]

I have an ADP on an user's system that is connected to a SQL Server 2000 DB. User A runs a report in the application and the report displays without any issue. User B tries to run the report but get a sp_Example is missing. The interesting part is when the user opens the database window of the ADP they can run the sp_Example without any issue. We have looked at all permissions on the SQL Server side for both users and they are identical. As far as I know both users are set up identically on the network as well. Does anyone have any suggestions on where I could look.
Thanks

 

[jsanbor1]

just a guess, but did you call it as "dbo.sp_Example"?

 

[yeagly21]

Thanks for the thought jsanbor1, but sp_Example was just the example that I was using. The application actually has the Stored Procedure in the report's Record Source without the dbo prefix. I will make the change and see if it helps, but why would it work for one user and not both?