Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

swati_rastogi27
Contributor

How to retrieve user id from connection string

Can someone help me find the id from QlikView connection string?

We had been using this connection string from over a year and the password to the id suddenly got expired.

To get more details or to reset password , we need the id.

Can someone help?

Tags (1)
11 Replies
vinieme12
Esteemed Contributor II

Re: How to retrieve user id from connection string

This isn't related to QV so I suggest you ask Google.

But if you had an ODBC/OLEDB connection, then you would also have a DSN in the ODBC admin

Hit windows key and search for ODBC

rahulpawarb
Valued Contributor III

Re: How to retrieve user id from connection string

Hello Swati,

You can refer the User ID field from connection string to get user Id (sample connection string is given below):

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=AdventureWorksDW2008R2;Data Source=RAHUL-PAWAR\SS2K8R2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RAHUL-PAWAR;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is JABcBYFMTbcOXXJOETHB);


Hope this will help.


Regards!

Rahul

swati_rastogi27
Contributor

Re: How to retrieve user id from connection string

My connection string within the application is like :

ODBC CONNECT TO MYDATABASE (XUserId is BGAcALDCTbcOXXJOETHB, XPassword is JABcBYFMTbcOXXJOETHB);

rahulpawarb
Valued Contributor III

Re: How to retrieve user id from connection string

Hello Swati,

It seems that you are using ODBC connection type using DSN with name MYDATABASE. You can find the the UserId in two ways:

1. Go to the ODBC Data Sources; locate the DSN with MYDATABASE and press configure button. On the next screen you can see the User Name field

2. In Edit Script, go to the Database section & select ODBC option. Post that press Connect. Select the ODBC with MYDATABASE name & Press OK. This will trigger a screen inquiring connection details; there you could find User Name.

Hope this will be of help.

Regards!

Rahul

Highlighted
swati_rastogi27
Contributor

Re: How to retrieve user id from connection string

Unfortunately I am trying to connect to DB2, using Adaptive Server Enterprise driver and I don't see the user Id there with the options you mentioned above.

For Oracle I am able to see.

Re: How to retrieve user id from connection string

You must have a driver installed in the server where the QlikView Distribution Service reloads, so you will need to update that driver there. Note that DSNs may have the user and password in their definition, so you may need to change them there.

Finally, note also that there are two odbcad32.exe for 32-bit and 64-bit connections. Although the name of the file is the same, they are in different folders

  • C:\Windows\SysWOW64\odbcad32.exe (32-bit)
  • C:\Windows\System32\odbcad32.exe (64-bit)

Yes, "SysWOW64" contains the 32 bit version while "System32" contains the 64-bit version (the one you see by default - https://support.microsoft.com/en-us/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and...)

josefaria92
New Contributor III

Re: How to retrieve user id from connection string

Hi Miguel,

Different topic, sorry.

Could you tell me if the user id in Qlik has a limited number of characters?

Why? I'm retrieving user mail truncated up to 20 characters and the mail is also the user id

Best Regards,

Gabriel

Re: How to retrieve user id from connection string

I'm not aware of any limitation other than the operating system and driver, but that's way longer than 20 characters. I have some deployments with usernames of 19 to 23 characters long working just fine.

josefaria92
New Contributor III

Re: How to retrieve user id from connection string

Thanks Miguel,

I also checked that within Qlik Repo DB, it's 500+ characters so it's not a Qlik Sense issue but from AD itself.

I verified within here SAM-Account-Name attribute (Windows) that AD syncs users with this atribute "SAM-Account-Name" that limits it to 20 characters because of older Windows versions. Is there a workaround so I can fetch the full lenght of the userid within AD?

Thank you