• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Executing SP through DMO

How would I execute a stored procedure using VB-DMO?
What syntax would I use?

Regards
0
ossentoo
Asked:
ossentoo
1 Solution
 
alvaroBCommented:
SQL-DMO is aimed at providing the user with objects to manage SQL Server from a VB application. In other words, you could do administrative tasks(backups, configurations,...) or look at the internal structure of a database(Tables,views,...) , using DMO. If you want to process data through a SP, the way to go could be ADO, RDO, or other technologies.

If you still want to execute a SP using SQL-DMO, you could try using the following methods of the SQLServer object:

ExecuteImmediate
ExecuteWithResults
(Check SQL documentation for details)

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now