Qlik Community

Qlik Sense Cloud Discussions

semlemmers
New Contributor II

Error: Connection 'dbname (khost_adminuser)' not found

Hi,

I (user1) have made an app in Qlik Sense using an ODBC connection, duplicated the app and changed its owner. The new owner (user2) tries to reload the data but gets this error:

The following error occurred:

Connection 'dbname (khost_user1)' not found

The error occurred here:

LIB CONNECT TO ***

What am I missing?

- It is not a rights issue. User 2 can access the database in a new app

- The ODBC connection is setup in windows to SQLServer

- Authentication is via NT name, but there's a connection string with (user1)-credentials

Thanks for helping out!

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Error: Connection 'dbname (khost_adminuser)' not found

By any chance, You saved Data Connection or changed anything to it?

Saving Data Connection changes name of that data connection followed by UserID which is used to edit connetion.

You can Try 1 thing.

In QMC, Edit Name of Your Data connection to 'dbname'

Also in Script, Change name of Connection in below line

LIB CONNECT TO 'dbname';

and then try to reload.

3 Replies
shraddha_g
Honored Contributor III

Re: Error: Connection 'dbname (khost_adminuser)' not found

You changed owner of App o Connection?

semlemmers
New Contributor II

Re: Error: Connection 'dbname (khost_adminuser)' not found

Both. At first the owner of the app to user2. Then the reload didn't work and then I changed the owner of the connection to user2, but it didn't solve the problem. Now the owner of the connection is set back to the original owner, user1.

shraddha_g
Honored Contributor III

Re: Error: Connection 'dbname (khost_adminuser)' not found

By any chance, You saved Data Connection or changed anything to it?

Saving Data Connection changes name of that data connection followed by UserID which is used to edit connetion.

You can Try 1 thing.

In QMC, Edit Name of Your Data connection to 'dbname'

Also in Script, Change name of Connection in below line

LIB CONNECT TO 'dbname';

and then try to reload.