Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Employee
Employee

Loading Data from An ODBC Source

Here is a quick view on how to load data from an ODBC data source.

http://www.youtube.com/user/QlikTips#p/u/1/STsYZHUoFrM

7 Replies
Not applicable

Re: Loading Data from An ODBC Source

The list of data sources are blank when I try to connect using ODBC. I cannot see any data sources in my window. Is there any solution for this?

rustyfishbones
Honored Contributor II

Re: Loading Data from An ODBC Source

What are you trying to connect to?

Re: Loading Data from An ODBC Source

To use ODBC you have to define a DSN first using Windows Control Panel to connect to the data.

Not applicable

Re: Loading Data from An ODBC Source

Thank you. I'm trying to connect to access (accdb) file and I see only mdb file in the list of User data sources in control panel. Maybe I need to post this issue in a different forum!

rustyfishbones
Honored Contributor II

Re: Loading Data from An ODBC Source

Hi,

When you connect what do you see in the Database Name, like below

2014-01-03_1616.png

If you only see .mdb, change it so it looks like above and then see if that Access DB is available

Not applicable

Re: Loading Data from An ODBC Source

Thank you again Alan. I installed the microsoft access database engine 2010 and now able to see both mdb and accdb as displayed in your picture. Problem solved. Thanks!

MVP & Luminary
MVP & Luminary

Re: Loading Data from An ODBC Source

Hi Sandeep,

The issue previously may have been that you were using a 64 bit driver and the old version of Access required a 32 bit driver to be used.  There is a checkbox in QlikView to force 32 bit when this is the case.

Steve