topic Another SQL Stored Procedure Question in QlikView

Another SQL Stored Procedure Question

Wed, 05 May 2010 04:45:28 GMT

I'm just testing at the moment but want to get the recordset loaded into Qlikview as returned from a stored procedure.

ALTER PROCEDURE dbo.pTest
AS
SELECT
ac_id
FROM
dbo.fcAccount

RETURN

Running "EXEC dbo. pTest" in MS SQL server it returns a recordset as expected.

In the Load script in Qlikview I have

CONNECT TO [Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FC;Data Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CHUCK-PC2;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False];

SQL EXECUTE dbo.pTest;

I don't get any errors so it appears to work ok but qlikview doesn't load any columns/rows.

Looks like I need to specifiy that it's returning a recordset some how. How do I do it.

I also tried

LOAD ac_id;

SQL EXECUTE dbo.pTest;

It didn't like it

Any ideas?

Cheers

Another SQL Stored Procedure Question

Thu, 06 May 2010 15:04:17 GMT

Hello,

Try using an ODBC instead a connection string. Something like:

ODBC

CONNECT TO ODBC01 (XUserId is LcZMDD, XPassword is aHQSPRMFBMaGCA);

Ids:

LOAD

ac_id;

SQL

EXEC BD01.dbo.pTest;

Steve

Another SQL Stored Procedure Question

Sun, 10 Jul 2011 23:49:44 GMT

Thank you, Steve! Switching to ODBC worked for me.

I had to use a user DSN - my File DSNs do not work. Just thought I would throw that out as it was frustrating me when my File DSNs were not showing up.