topic Re: Stored Procedure in Qlik View in QlikView

Stored Procedure in Qlik View

im_ps — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to use Stored Procedure from SQL Server in Qlik View. Went through different Links in the Qlik Community, but wasn't much helpful.

Tried using the below code but Db was not getting connected:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;
Persist Security Info=True;
User ID=sa;
Initial Catalog=DB_9B08BD_automobile;
Data Source=localhost;
Use Procedure for Prepare=1;
Auto Translate=True;
Packet Size=4096;
Workstation ID=DEVELOPER-PC;
Use Encryption for Data=False;
Tag with column collation when possible=False]
(XPassword is EOIeQYIGTBNKDbEF);

As I am new to QlikView can someone help me with this.

Regards and Thank you in Advance,

im_ps 🙂

Re: Stored Procedure in Qlik View

dapostolopoylos — Tue, 17 Sep 2019 10:44:22 GMT

The code you posted is a connection string to a db.

Is this the db you want to work with?

Have you ever worked with a relational db and SQL?

Re: Stored Procedure in Qlik View

asinha1991 — Tue, 17 Sep 2019 10:47:34 GMT

try to create a connection from create connection button in load script, click on test connection and see what the error is.

Can be anything from server not in domain, wrong authentication, db doesn't exist etc etc