Rif.: Eseguire una store procedure da labview

[sepp974]

Ciao,
qualcuno sa dirmi come si fa ad eseguire all'interno del codice labview una store procedure che interroga un database di sql server?

Grazie,
Giuseppe

[sepp974]

I'm sorry.. this isn't the italian forum..

but the question is:

how can I execute a store procedure of a sql server database with labview?

Thanks,

Giuseppe

[MarcoMauri]

Hi!

you can use the "DB Tools Create Parameterized Query VI" provided with the Labview Database Connectivity Toolkit.

I've found quite tricky to use stored procedures with output parameters.

Regards,

Marco

[sepp974 · Accepted solution]

Thanks,

I solved with this example

http://digital.ni.com/public.nsf/allkb/07FD130746083E0686257300006326C4

[MarcoMauri]

Hi Giuseppe,

did it work even for stored procedures wirh output parameters?

Marco

[sepp974]

Yes, this exemple shows how to read an output of a stored procedure