topic Reload stops for entering password which is null in QlikView

Reload stops for entering password which is null

Sun, 31 Mar 2013 06:57:27 GMT

Hi all,

My connection to the ODBC requires a user name yet not a password.

I tried:

ODBC CONNECT TO SalsSQL (UserID is Admin, Password is '');

It doesn't work.

also:
ODBC CONNECT TO SalsSQL (UserID is Admin)

When I'm reloading I need to hit enter when it reaches the connection string otherwise it wont move.

Re: Reload stops for entering password which is null

Miguel_Angel_Baeyens — Sun, 31 Mar 2013 08:28:43 GMT

Hi,

Ideally, if the DSN has the user and password properly configured in it, you don't need to specify them in the load script. Try and set up your DSN in Windows to store the user and password and not set them in the script.

Hope that helps,

Miguel