Configurable ODBC in Qlikview server

[bhargav_bhat]

Hi,

I am trying to connect to the  User Directory through configurable ODBC  in Qlikview Management Console.But I am getting an error  as

Exception when connecting to the data source

Error:IM002  Data source name not found nad no default driver specified

Can anyone help me  on the steps that needs to be followed for successful connection

Regards,

Bhargav

[awhitfield]

Have you actually created the required DSN first?

Andy

[bhargav_bhat]

Hi,

I have created the DSN and in the path I have given  ODBC://localhost

and given username and password  of the admin user

[awhitfield]

What's the full CONNECT line in the script?

[bhargav_bhat]

Hi Andrew,

when I connect through same DSN in QLikview application in the script it appears as

ODBC connect to TEST_ODBC;

select *  from  Db.Test.Table

But when I try to connect through Configurable ODBC in QMC I am getting the above error

can you please suggest me the steps that needs to be followed

Regards,

Bhargav

[awhitfield]

Re:

But when I try to connect through Configurable ODBC in QMC I am getting the above error

can you please suggest me the steps that needs to be followed

Please supply a screen shot that shows what you are trying to do.

Andy

[Peter_Cammaert]

System DSN or User DSN?

A User DSN will be visible to you and can be used in QV Desktop.

A System DSN will be visible to all, including the DSC/QMS/QDS/QVS service account.

[bhargav_bhat]

Hi below is the screenshots

I have  given admin user's name and password 

In Data source name given DSN name

for entity name given the name of the column in the table in database having entity name

for Entity table db name gave the name of the table in database

for Groups table gave the Groups table name

for Conn db  name gave the database name

[awhitfield]

Hi Bhargav,

sorry never used that, check out the attached Help Link which may help:

Andy

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/QMC/Content/QMC_System_Setup_DirectoryServicePro...

[bhargav_bhat]

Hi Peter,

Thanks for replying

I have used System DSN only