Error calling a stored procedure

[Anonymous]

Hi guys..

Trying to run a fairly simple stored procedure from QV

QueryTable:

Load

*;

SQL $(vSQL);

I set my $(vSQL); in a button with action like:

= 'exec [DB].[dbo].[sp_trace] @batch = ' & chr(39) & vBatchID & chr(39)

vBatchID is set via inputbox.

The $(vSQL) ends up like:

exec [DB].[dbo].[sp_trace] @batch = '22081210212296004'

Running this from ms sql returns data.

But when I try to execute in QV I get this:

Error: File extdata.cpp, Line 2777

SQL EXEC [DB].[dbo].[sp_trace] @batch = '22081210212296004'

I do not see why????

Any advise

BR

Dan

[MayilVahanan]

HI

Please go through this link..

edit:

archanah, Johannes Sunden posts are help you.

http://community.qlik.com/thread/3223

or

try like this

LOAD *;

SQL EXEC sp_text '20100101','20100530';

[Anonymous]

Hi.

I have read that thread it provides no help to me at all.

I testet with

exec sp_who and that runs as it should.

[MayilVahanan]

HI

I tried with select statement in variable using action button and reload it.. it  works.

May be it helps..

[lukas_sokol]

I have similar problem and when I use ODBC instead OLEDB Connect then it works.