topic Re: Odbc connection issue in QlikView

Odbc connection issue

Wed, 25 Nov 2020 16:16:04 GMT

Dear Expert,

I am getting below error while create DSN for ODBC connection in qlikview.

regards

tripati

Re: Odbc connection issue

Peter_Cammaert — Thu, 26 May 2016 15:35:19 GMT

And what exactly is your question?

Maybe this can help: the dialog says that you cannot login to SQL Server with the credentials supplied. Either the username or the password or both are incorrect.

If you are using Windows credentials (SSO), then your current account or the account that executes the CONNECT statement has not enough privileges to log in. A database like SQL Server maintains its own list of users with access.

Peter

Re: Odbc connection issue

qlikview979 — Fri, 27 May 2016 06:59:24 GMT

Hi Tripati,

Try like this If u have Oracle in your system.

Goto Script-->Tools---> select ODBC Administrator 32 Bit---->System DSN--click on ADD Button

Then new Window will be opened select what you have in system Ex:- if u have "Oracle" select that ---->click on Finish Button. Then New window will be Opened -->Create name like(Tripati DB) and give your Oracle User name like(ex:-Scott) Then Click on Finish.

Then click on Connect in Qlikview Backend Select yourDB name Then Give your username,Password like(Scott,Tiger) now your ODBC will configure. then link will come.

Click on select then select table now ODBC connection is done save your QVW then go for Reload .

If u have SQL process will be different.

Regards

Mahesh.

Re: Odbc connection issue

Anil_Babu_Samineni — Fri, 27 May 2016 07:50:04 GMT

Did you create the DSN?

If yes, Please let me know what process you are following to connect the ODBC...