Qlik Sense SQL Connection

[sona_sa]

Hi

I am trying to connect, Below is my scenario:

By Using this:

I am getting this window and Here I am not able to able to connect any Data source.

By using this Script Editor:

I am getting this window when I am tring to create Connection String.

Also when I am creating a DSN for SQL Database connection, after putting all required information, Database connectivity tested successfully, After that I am getting this below error.

Please help me in the same. Is there any setting I need to do in QMC level.

Thanks.

[Sebastian_Linser]

Hello,

are you trying to use Qlik Sense Desktop or Qlik Sense Enterprise for Windows?

If you use Qlik Sense Enterprise for Windows there might be some security rules in place to block you from using certain connectors. The list should normally be much longer. If you try with Qlik Sense Desktop it seems your user is locked down and has not full read / write access to all the necessary places.

On your second problem with the ODBC connection which can't be saved, if you try to create a system wide ODBC connection you have no writing permissions in:

HKEY_LOCAL_MACHINE\Software\ODBC

The connection test will always run fine as long as you have access to the data source, because it will use the connection details in memory.

kind regards

Sebastian

[PadmaPriya]

Hello @sona_sa ,

Thanks for posting your query.

Error message:

Driver’s ConfigDSN, ConfigDriver, or ConfigTransliterator failed – Could not write to the registry

Cause:

Windows stores SYSTEM ODBC data sources under HKEY_LOCAL_MACHINE\Software\ODBC.
When a user is logged on as regular user without administrator privileges, it is not possible to write to the registry tree.

Solution 1:

• Either create the system data sources when logged on as an Administrator account
• Or grant the user privileges to write to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
• Or run the ODBC Administrator using "Run as Administrator"

Or Solution 2:

Instead of creating a system data source, create either

• a user data source (stored at HKEY_CURRENT_USER\Software\Odbc) or
• a file data source

Thanks,

Padma Priya