Odbc connection issue

[#1]

Dear Expert,

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

regards

tripati

[Peter_Cammaert]

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

[qlikview979]

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.

[Anil_Babu_Samineni]

Did you create the DSN?

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