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
lkprotection wrote:
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.