Unable to run stored procedure on IN-DB Connect/Data Stream Output
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Frantically
5 - Atom
‎05-18-2022
12:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hiyo,
No idea if this has been asked before but I'm having issues with running stored procedures through the Ole DB Provider for SQL Server.
On the attached image, it says there's an invalid object name but the stored procedure does exist and it looks like it's trying to select it as if it's a table. It works fine when I select a normal table but not when I execute stored procedures. Is there any way I can get the stored procedure to execute, if possible?
Thanks!
Labels:
- Labels:
- Output
2 REPLIES 2
gabrielvilella
14 - Magnetar
‎05-18-2022
06:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't think it is possible to run stored procedures using the In-DB tools. It is possible to call them if you have a regular Input/Output data tool within the pre/post SQL statement area.
‎05-19-2022
05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Looks like it, yep. Thanks for the reply!
