Stored Procedure in Qlik View

[im_ps]

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 🙂

[dapostolopoylos]

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?

[asinha1991 · Accepted solution]

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