Has anyone successfully used the sp_setapprole and sp_unsetapprole SQL Server stored procedures with LabVIEW? I'm struggling to get the parameters right, apparently. I can make it work by building a SQL query string and sending that straight to an Execute Query VI, but I want to return the cookie value, and I'm not sure how to do that. I'd like to use the Create Parameterized Query with the Set Parameter Value and Get Parameter Value VIs, but haven't had any luck making that work. Thanks!

If the cookie is the only thing returned, there won't be a recordset like there is with a SELECT query. I think you have to use the parameterized query in this situation. I have never used the {call procedure(?,?)} format. I only use the name of the SP as the query. This is documented in the help file that way. And I also create the parameters as shown here, rather than using the SET function. This is a bit cleaner IMHO and it's really easy to add another parameter if necessary. What happens if you use string for the cookie value? VARBINARY does not correlate to any datatype in LabVIEW so I would try string format. Since this procedure belongs to the master database, you may have to set your default catalog to master (in connection settings). I've never had to call a system SP to know for sure. Maybe the server automatically recognizes it as a system SP.

LabVIEW

Using sp_setapprole SQL Server stored procedure

Solved!

@KevinHarter wrote:

Now I just need to figure out what the LabVIEW equivalent of a varbinary(8000) is.

I think it would be best to try to use a string datatype instead of a binary datatype. I've never tried it myself so I don't have any tips to give you. Good luck.

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.