Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Error message when trying to connect to an ODBC data source

Hi All, I'm new to Qlik sense, receiving this error message when trying to connect to an ODBC data source, which I can connect to with no problem in Qlkview 11,  error message:"You do not have access to a script data source", any advice appreciated.

10 Replies
Employee
Employee

Re: Hi All, I'm new to Qliksense, receiving this error message when trying to connect to an ODBC data source, which i can connect to fine in Qlkview, error message:"You do not have access to a script data source", any advice appreciated.

James,

Are you logged in as the same account that Qlikview works? or a different account?

gio

MVP
MVP

Re: Hi All, I'm new to Qliksense, receiving this error message when trying to connect to an ODBC data source, which i can connect to fine in Qlkview, error message:"You do not have access to a script data source", any advice appreciated.

Hi,

First, make sure it is a System DSN and not a User DSN.

Second, make sure it is a x64 bit version of the ODBC driver, since in Windows you can have both (32 and 64).

Miguel

Employee
Employee

Re: Hi All, I'm new to Qliksense, receiving this error message when trying to connect to an ODBC data source, which i can connect to fine in Qlkview, error message:"You do not have access to a script data source", any advice appreciated.

In QlikView - are you forcing  32-bit?

Sense is 64-bit only, so perhaps you need to configure a 64-bit version of the ODBC driver.

Mike T

Regards,
Mike Tarallo
Qlik
Employee
Employee

Re: Hi All, I'm new to Qliksense, receiving this error message when trying to connect to an ODBC data source, which i can connect to fine in Qlkview, error message:"You do not have access to a script data source", any advice appreciated.

Dear James,

I do not see any response? I notice you are going over and over, are you having problem with the Qomunity posts?

Gio

Employee
Employee

Re: Error message when trying to connect to an ODBC data source

Hi James - I needed to update the title of the post. We also were not receiving any of your replies, they were coming across blank. It might have been related to the title being so long or something.

Please review the proposed solutions and let us know how you make out.

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
mwoolf
Honored Contributor II

Re: Error message when trying to connect to an ODBC data source

I was able to connect to a Notes 32 bit driver with no problems.

I got an error when I added connect 32, but without that line all was good.

Not applicable

Re: Error message when trying to connect to an ODBC data source

Hi Michael,

Thanks to all for your help, also apologies, i'm very new to the community and just finding my way around.

I have now managed to connect to the database by manually setting the datasource here :

C:\Windows\SysWOW64\odbcad32.exe, The 32 bit option in system dsn then became available and connected first time.

James

Not applicable

Re: Error message when trying to connect to an ODBC data source

Thanks for your help and advice.

James

Not applicable

Re: Error message when trying to connect to an ODBC data source

Thanks for your help and advice.

James

Community Browser