Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VM Pro DB action with MSSQL Stored Procedure

Status
Not open for further replies.

janni78

IS-IT--Management
Aug 25, 2005
5,125
SE
Hi, having the same problem as this post [URL unfurl="true"]http://www.tek-tips.com/viewthread.cfm?qid=1476435[/url]

Can't for my life get the result of a stored procedure in VM Pro.
It executes the command as it should but can't figure out how to get the result, Database Get Data action doesn't work.

19/04 17:05:28.058 vmprov5s (06,8) 1cac,3a38: SOCKSTask::SendBuffer(VMServer [SOCKSTask] port 50791): Sending "VMMESSAGE_UTF8MONITOR Session=00000000, Seq=0, length=70, Data=VMAIL F:79"Database Operation", "Get Data", "No Data to get"" to server "xxx.xxx.xxx.xxx"

I can use "select @@returnStatus" in for example HeidiSQL to get the result.

Anyone used stored procedures in VM Pro and managed to store the result?

"Trying is the first step to failure..." - Homer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top