sqllink plugin - running a stored procedure

[lkprotection]

I can run a regular select statement no problem but I am not sure what the syntax would be to run an SQL 2000 stored procedure via the ODBC driver. I've tried different things but cannot figure it out. Please help.

[paulc]

What have you tried exactly? can you post the statement?

 

I can run update statements etc fine, so unless theres a timing issue, ie the SP takes an age to execute or something, it should work.

 

Without trying it, I would guess it should be

 

"exec dataname.dbo.UpdateDatabase '%callid%'"

 

where UpdateDatabase is the SP name and callid a variable passed from IVM to SQL

 

Post yer statement and the error/problem and I'd be happy to try to help

 

 

Paul

 

 

 

I can run a regular select statement no problem but I am not sure what the syntax would be to run an SQL 2000 stored procedure via the ODBC driver. I've tried different things but cannot figure it out. Please help.