Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload stops for entering password which is null

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.

1 Reply
Miguel_Angel_Baeyens

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