Database first wizard does not show stored procedures

2 posts, 0 answers
  1. Lisa
    Lisa avatar
    16 posts
    Member since:
    Nov 2013

    Posted 28 Apr 2014 Link to this post

    I am adding a second OA model to my solution so that I can access a stored procedure in a different database. When I use the set up wizard (database first) and get to the Add Database Items screen, none of the stored procedures are listed or available to select. Any idea why stored procedures do not show up in the wizard? I was able to add stored procedures from the first database to the first model. I do have permissions to execute stored procedures on the second database.
    THanks
  2. Lisa
    Lisa avatar
    16 posts
    Member since:
    Nov 2013

    Posted 28 Apr 2014 in reply to Lisa Link to this post

    It turns out I did not have sufficient permissions to execute the stored procedure after all. Once I fixed that, it did appear in the dialog box as expected.
    I still have a problem executing it, but I will post that in a separate thread.
  3. DevCraft banner
Back to Top