topic Microsoft Jet 4.0 OLE DB Provider in QlikView

Microsoft Jet 4.0 OLE DB Provider

Tue, 09 Jun 2009 20:45:24 GMT

I am trying to connect to an MS Access Database. When I try to connect using OLE DB I do not see the Microsoft Jet 4.0 OLE DB Provider. The server Admin says that we have MDAC 2.8 SP2 installed on the server. We do not have the whole MS suite installed. What are we missing?

Thanks!

Microsoft Jet 4.0 OLE DB Provider

rwunderlich — Wed, 10 Jun 2009 10:00:28 GMT

Is this 32bit or 64bit Windows?

-Rob

Microsoft Jet 4.0 OLE DB Provider

Wed, 10 Jun 2009 20:02:38 GMT

Yes.

Microsoft Jet 4.0 OLE DB Provider

rwunderlich — Thu, 11 Jun 2009 01:13:53 GMT

What I meant to ask was: Which OS is it, 32bit or 64bit?

I've seen some posts on this forum about unable to load Access DBs on the 64bit platform. If you are 64bit, you might try searching the forum or reposting the question like "Loading Access tables on 64bit".

-Rob

Microsoft Jet 4.0 OLE DB Provider

Thu, 11 Jun 2009 04:23:40 GMT

Yes we are running on a 64 bit OS. I did a search but can't seem to find anything. What we don't have install is the full MS suite including MS Access. We only have the MDAC installed. I was wondering if we need the applications installed as well.

Microsoft Jet 4.0 OLE DB Provider

rwunderlich — Thu, 11 Jun 2009 08:22:02 GMT

I found this thread in the old forum

http://community.qlik.com/forums/p/12864/54500.aspx#54500

It deals with ODBC, not OLE/DB, but the limitation may be the same.

You might try reposting your question to this forum as "Loading Access tables in 64bit" to see if anyone else has any workarounds.

-Rob

Microsoft Jet 4.0 OLE DB Provider

Wed, 29 Sep 2010 13:44:44 GMT

Did you get it working? I'm trying to run the Developer 1 e-learning course (on Windows 7 64bit) and cant access the sccess db because I can't find the jet 4.0 driver

Microsoft Jet 4.0 OLE DB Provider

Wed, 29 Sep 2010 14:51:35 GMT

Yes, use the OLE DB connection and enter the path. The connection string in the script looks like this:

MSQuery:

CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=\\servername\Path\DatabaseName.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False];

SQL SELECT *

FROM `Table Name or Query Name`;

I hope this helps

Microsoft Jet 4.0 OLE DB Provider

Wed, 29 Sep 2010 14:51:36 GMT

Yes, use the OLE DB connection and enter the path. The connection string in the script looks like this:

MSQuery:

SQL SELECT *

FROM `Table Name or Query Name`;

I hope this helps

Microsoft Jet 4.0 OLE DB Provider

Mon, 19 Dec 2011 23:14:25 GMT

check the " Force 32 Bit" box ?

Re: Microsoft Jet 4.0 OLE DB Provider

Anonymous — Thu, 31 Jul 2014 11:23:03 GMT

You need to check the "Force 32 Bit" in Data panel in script window.

Re: Microsoft Jet 4.0 OLE DB Provider

jim_chan — Mon, 28 Nov 2016 13:02:32 GMT

why need to check force 32bit ?