topic Re: ODBC Import Issue in QlikView

ODBC Import Issue

gfisch13 — Thu, 15 Oct 2015 18:38:32 GMT

Good Afternoon -

I've encountered a problem with an ODBC connection I'm making to an SQL database.

I've setup the connection and have successfully connected to the database using MS Access, but when I try Qlikview I receive error messages that are indicative of an ID that does not have permission to access the database. Can anyone explain this, or have experienced this?? I've reached out to my local site support and the database owners to resolve, but I just wanted to see if there was some giudance here as well.

Thanks! George

Re: ODBC Import Issue

crystles — Thu, 15 Oct 2015 18:54:51 GMT

Are you trying to connect to a SQL database or an Access database?

Re: ODBC Import Issue

gfisch13 — Thu, 15 Oct 2015 18:57:47 GMT

Thank you for your reply!! I'm trying to connect to a SQL database..........I tried the connection in MS Access to see if it worked.

Re: ODBC Import Issue

qlikviewwizard — Fri, 16 Oct 2015 04:15:29 GMT

Check if the given user id have the access on the tables... Hope it will help you.

Re: ODBC Import Issue

avinashelite — Fri, 16 Oct 2015 06:11:07 GMT

Check the username and password once and also check whether your ID have access for all the tables and fields

Re: ODBC Import Issue

crystles — Fri, 16 Oct 2015 15:51:09 GMT

If you are trying to connect to a SQL database, I would use the OLE DB connection.

It gives you a list of options, so just select the Provider for SQL Server (see image below). That should allow you to connect if you have the permissions.

I do not think you can connect to a SQL database with the MS Access connection.

Re: ODBC Import Issue

qlikviewwizard — Mon, 19 Oct 2015 07:25:42 GMT

Hi George , Did you able to get the solution? Let us know if there is any issue.

Re: ODBC Import Issue

gfisch13 — Mon, 19 Oct 2015 15:32:36 GMT

Thanks for your response - nothing is working so I'm waiting for IT to fix my permissions. This is the lower environment that I usually don't have access to.

Re: ODBC Import Issue

gfisch13 — Mon, 19 Oct 2015 15:33:35 GMT

Thanks for your response - nothing is working so I'm waiting for IT to fix my permissions. This is the lower environment that I usually don't have access to.

Re: ODBC Import Issue

avinashelite — Tue, 20 Oct 2015 06:59:13 GMT

once you get the access you should be able to load the data..

if you have got the answer please mark the correct answer and close this thread

Re: ODBC Import Issue

gfisch13 — Tue, 20 Oct 2015 14:18:12 GMT

Thank you all for your responses. I've come to discover that I was in the wrong domain and IT has now pointed me in the right direction and I've successfully connected to my data source. Sorry for any confusion, I'm still learning the layout of our businesses!!