Discussion Board for collaboration related to QlikView App Development.
Can anyone please help me with this below error pop up , not able to connect to SQL DB.
Am using OLEDB and i have Server name , user ID and PWD.
Provider - Microsoft OLE DB provider for SQL server.
attaching the error image please help me out, its kind of urgent.
Yes Vishal ,
thanks for your reply,
I can but they are different , they just provided access to my windows ID so i can able to login and check the SQL DB.
Am allowed to write Queries also.
But coming to Extraction of the data from Qlikview, what we need exactly ??
I have server name , and Database Name that's it, ETL team is saying they have given access to my Windows ID, which is not working here.
Please help me which User ID and PWD (who will provide those details,do we need admin rights to extract) we use to connect and extract the data...???
To connect using your windows credentials select the "use Windows NT Integrated Security" option.
If you use this setting, remember that the server reloads will run using the credentials of the QlikView Distribution Service login, which may have different permissions to your login.
Try the following connection string in your script..
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=UID;Initial Catalog=YOURCATALOG;Data Source=SQLSERVER.YOURDOMAIN.local;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False] (Password is '*****');
Hi Colin , thanks for the response ...
am working on a personal edition later on we are going to deploy it on users Qlik set up.
if i make connection with the windows authentication , i don't c any data in the server.
ETL People are keep on saying that they granted access to me, even am also able to login into SQL DB.
Am really in Confusion what is going wrong here.
what exactly do we need to extract the data from SQL , as i am working on Direct discovery i have to fetach data from View.
Please help me.