Can not execute SQL SEVER Stored Procedure in Qv

[#1]

Hi Everyone,

Anybody knows how to load data from stored procedure?

I need to load data from sql server Stored Precedure in Qlikview. But each time no data or table loaded without error message.

Connect to sql server OK. The script work fine in sql server client.

I wrote the script like this:

Below is the ending snapshot after finished reloading.

[#2]

No. everything is fine. Thank you.

[markodonovan]

Is the 'Generate Log' option on in the Document properties ?

If so, can you check the log for any problems.

Thanks

Mark

techstuffybooks.com

[sorrakis01]

Hi Duo,

A simple question: Can you connect to the database and load a simple query, without problems?

Regards,

[#5]

Yes, without any problem.

I'm trying Normelio Junior's solution as you recommended.

1. I have checked "Open database in Read and Write mode"

2. Add "Mode is write".

    The difference between me and the example Normelio Junior posted is that i have no user name and password because i log on to server by Windows profile.

3. Correctly wrote the script calling the stored procedure.

But No data and table returned. I don't know why.

[Anonymous]

can you check which user is connecting to SQL Server from qlivkiew?

can you try to open SQL Server with same user and see if you can execute stored procedure?

mostly qlikview is using a technical user while connecting to SQL Server is done by your Windows user

both Need same permissions, please check

[sorrakis01]

Hi,

then use the counsel of Mark. Generate the Log.

Another question: You can call this procedure from another software and it response ok?

Regards

[#8]

Thank you. I looked the log file.

There is a parameter "ScriptWantsExe" which value is "false".  May this caused the issue？

[markodonovan]

Mine is false and works ok.

Must be something else.

Mark

[markodonovan]

What does it say in the log when your call the stored procedure?

Mine is like this:

31/07/2015 10:37:17: 0076  OLEDB CONNECT*Provider*

31/07/2015 10:37:17: 0078  load *

31/07/2015 10:37:17: 0079  sql exec get_test_data

31/07/2015 10:37:17:           1 fields found: branch, 19 lines fetched

31/07/2015 10:37:17: 0082  exit script

31/07/2015 10:37:18:      Execution finished.

Thanks

Mark

techstuffybooks.com

[#11]

I used my Windows Account and Password when logging on to sql server both from qlikview and sql server management studio.