ODBC connection with different user

Wed, 10 Oct 2012 06:49:36 GMT

Hi all,

hope someone can help me on this topic.

I have a windows 7 server and created a ODBC connection to a sql-server.

For the login into Windws we have to use a different user than for using the ODBC connection. The windows user has no rights to connect to the sql-server.

therefore I have to use a different user for the ODBC connection.

Is it possible to integrate a user in the Qlikview ODBC connection ?

Many thanks in advance for your help.

Best regards

Markus

Re: ODBC connection with different user

Miguel_Angel_Baeyens — Wed, 10 Oct 2012 08:01:44 GMT

Hi Markus,

QlikView calls Windows when you click on the Connect or Select button and ODBC is selected, so it all depends on how you OS is configured. If you set up any DSN, you can specify the username and password within the DSN, so the users don't need to know them. But if you mean you are connecting to a MS SQL Server using integrated Windows Authentication, in the ODBC Wizard you cannot set which user you want to use, so credentials used are those from the user actually logging on to the computer.

Hope that helps.

Miguel

EDIT: Reviewed

topic ODBC connection with different user in QlikView

ODBC connection with different user

Re: ODBC connection with different user