Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
im_ps
Contributor
Contributor

Stored Procedure in Qlik View

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 🙂

 

 

1 Solution

Accepted Solutions
asinha1991
Creator III
Creator III

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

View solution in original post

2 Replies
dapostolopoylos
Creator III
Creator III

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?

Father/Husband/BI Developer
asinha1991
Creator III
Creator III

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