SQL query with actxserver
2 views (last 30 days)
Show older comments
I am trying to run a SQL stored procedure that returns a parameter but I can't figure out how to get that value. When I run this psuedo code I get an error saying I need to define the output parameter. I know the DB connection is correct and works because I have other stored procedures that work but none of them have output.
DB = actxserver('ADODB.Connection') DB.Open( serverstuff here) DB.Execute('exec procedurename @inputParam=string')
0 Comments
Answers (1)
Madhura Suresh
on 31 Jan 2014
Have you tried using fetch?
a= DB.exec(query) data=fetch(a)
2 Comments
Madhura Suresh
on 5 Feb 2014
What version of MATLAB are you using? SQL queries might work, but there is no workaround for stored procedures using ACTXSERVER.
See Also
Categories
Find more on Shifting and Sorting Matrices in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!