topic There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0? in QlikView

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

Fri, 30 Jul 2010 19:41:35 GMT

Hello Everybody,

In qlikview 8.5 we already have ODBC driver installed, but in qlikview 9.0 there is no ODBC driver. Do i need to install drives seperatly,is it availabe for download.

or/////

IF possible ....how can connect to datasource(MS Access database) without ODBC driver?

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

Miguel_Angel_Baeyens — Fri, 30 Jul 2010 20:52:42 GMT

Hello,

ODBC drivers must be installed on your operating system. If you are using a 64 bit system, it may be available for 32 bit applications but not for 64 bit version of QlikView.

You might be able to select OLE DB Jet driver for MSAccess anyway.

Hope that helps

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

pablolabbe — Sat, 31 Jul 2010 03:58:20 GMT

There isn´t an ODBCconnection to qlikview 9, but it will be back in version 10.

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

stevedark — Sat, 31 Jul 2010 23:36:56 GMT

Hi There,

ODBC drivers are to do with your machine set up rather than QlikView. You probably want to download and install the Microsoft MDAC drivers from: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=78cac895-efc2-4f8e-a9e0-3a1afbd5922e

If possible it is usually to use OLE DB to connect to data sources rather than ODBC. You tend to get better throughput with OLE DB.

Hope that helps,
Steve

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

klaus_feldam — Tue, 10 Aug 2010 23:47:21 GMT

I have not found any help with MDAC or MS Office for the challenges we were having with MS Access ODBC drivers in our QlikView 9 64-bit environment. I spent several days looking into this and tried everything, until I finally found a solution. This one works, guaranteed:

Install Microsoft Access Database Engine 2010 Redistributable on your 64-bit server and you have your 64-bit MS Access driver. It works like a champ:

http://www.microsoft.com/DownLoads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

Please note: Both the 32-bit and 64-bit versions are available on this page. Make sure you download and install AccessDatabaseEngine_X64.exe.

Good luck!

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

Wed, 11 Aug 2010 00:47:02 GMT

Thank you all for your response,

hi! klaus.feldam..........i ll try with Microsoft Access Database Engine 2010..........

Thank you again

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

Wed, 11 Aug 2010 00:52:54 GMT

Thank you all for your response,

hi! klaus.feldam..........i ll try with Microsoft Access Database Engine 2010..........

Thank you

Patel

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

pablolabbe — Wed, 11 Aug 2010 02:12:14 GMT

My mistake.

Do you need microsoft office or Access installed to get the ODBC Drivers.

Somewhere in microsoft site you can find an installer with ODBC Drivers only.

There is no ODBC driver in qlikview 9? How to get ODBC driver for qlikview 9.0?

yasus — Fri, 26 Nov 2010 12:44:19 GMT

Well, I can't find any ODBC Driver for Qlikview in the 10th version. Any ideas how I can use the old 8.5 driver to use Qlikview as data source in Excel? I've installed both. Qlikview 8.5 and 10, but when trying to select Qlikview as data source in Excel version 10 opens obligatory which do not support Qlikview tables as a source. I had no problems with Qlikview 9.0 using the old 8.5 driver.