×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error when trying to select an SQL Server stored procedure for report

Error when trying to select an SQL Server stored procedure for report

Error when trying to select an SQL Server stored procedure for report

(OP)
I am trying to create a report through Info Report Designer. I create new report -> SQL/ODBC. Then sasys choose an SQl Table for the SQL Database selected. So I choose a stored procedure. The server name and database are correct otherwise I wouldn't get the SQL table listing. The server type I am using is OLEDB - SQEDB MS OLE (SQL Server).

Once I select the storedproc and click OK, I get the following error - "Microsoft OLE DB Provider for SQL Server: Could not find stored procedure 'CAC.dbo.sp_Process_Payments' even though it let me select it from the list. I can select a table or View no problems. Please Explain!!

Greatly appreciate some insight into this.

Cheers,
Kurt

RE: Error when trying to select an SQL Server stored procedure for report

Is the account you're using to connect the report to the database part of the dbo group?

RE: Error when trying to select an SQL Server stored procedure for report

(OP)
I log into Info Desktop with full admin rights.
Then I create a new report in designer and select SQL/ODBC. I point to the database and I have tried logging in using the sa account and my account which is the equivalent of dbo. I get a list ofo all objects in the database, so that doesn't seem to be an issue. It does the same for other databases as well.

Whats the difference between a report using a view and using a stored procedure within this context?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close