topic Re: Loading Data from An ODBC Source in QlikView

Loading Data from An ODBC Source

Josh_Good — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Loading Data from An ODBC Source

Fri, 03 Jan 2014 15:39:43 GMT

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?

Re: Loading Data from An ODBC Source

rustyfishbones — Fri, 03 Jan 2014 15:44:50 GMT

What are you trying to connect to?

Re: Loading Data from An ODBC Source

Colin-Albert — Fri, 03 Jan 2014 15:47:10 GMT

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

Re: Loading Data from An ODBC Source

Fri, 03 Jan 2014 16:16:14 GMT

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!

Re: Loading Data from An ODBC Source

rustyfishbones — Fri, 03 Jan 2014 16:20:38 GMT

Hi,

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

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

Re: Loading Data from An ODBC Source

Fri, 03 Jan 2014 16:34:28 GMT

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!

Re: Loading Data from An ODBC Source

stevedark — Fri, 03 Jan 2014 16:52:32 GMT

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