SQL query with actxserver

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')

Answer 1

[Madhura Suresh]

Have you tried using fetch?

a= DB.exec(query) data=fetch(a)

[Reese]

There is no fetch command in base matlab. It is in the datafeed or database toolbox which I don't have.

[Madhura Suresh]

What version of MATLAB are you using? SQL queries might work, but there is no workaround for stored procedures using ACTXSERVER.